How can the developer address this need with a LookML object?

A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count”...

November 11, 2021 No Comments READ MORE +

What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?

A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View fromTable functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore. What can the developer add to the Explore to limit the number...

November 10, 2021 No Comments READ MORE +

How can the developer determine to which fields this parameter should be applied through SQL Runner?

A developer has User Specific Time Zones enabled fora Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time...

November 10, 2021 No Comments READ MORE +

Which action should thedeveloper take?

A developer defines the following measure in the order_items view: The code must validate without errors. Which action should thedeveloper take?A . Join order_items and inventory_items in a derived table.B . Join order_items and inventory_items in the same Explore.C . Copy the cost definition from inventory_items to the order_items view...

November 9, 2021 No Comments READ MORE +

Which two options should the developer evaluate to improve dashboard performance?

Users report that the main dashboard has been slow toshow results. Which two options should the developer evaluate to improve dashboard performance? (Choose two.)A . Number of databases used by dashboard elementsB . Number of queries used by the dashboardC . Ratio of visualizations to text tilesD . Format used...

November 8, 2021 No Comments READ MORE +