4/18/2023 0 Comments Mindomo drill downFigure 3: If using the approach to drill-downs described in Figure 2, clicking on a metric on a dashboard displays the drill-down functionality as “Show All $806,984”, which does not provide any information about what the metric is being drilled down by.Īn approach that addresses both of these shortcomings is to use the link parameter (instead of the drill_fields parameter) in the definition of the measure. These two drawbacks ultimately worsen the user experience. Not only does this approach not allow you to have more than one drill-down, it also does not give you the option to specify what you want to label the actual drill-down. However, the approach of Figure 2 only allows you to enable single drill-down, which is demonstrated in Figure 3. In such a case, it would be useful to break the revenue metric down by country (see Figure 1) this is exactly what a drill-down allows you to do.įigure 2: The LookML code for creating a single drill-down for a measure. For example, suppose you are looking at a single metric of the total revenue of your business this quarter, but you are interested in seeing which countries brought in the most revenue. A drill-down allows you to drill into the details of a metric by giving you a view of row-level information of the records that comprise that metric. So, if you are interested, keep reading!ĭrill-down capabilities are a key feature of any good BI platform. When reporting on key metrics in a business, one of the most common questions that clients ask us is: how can we gain further insight into a specific metric? How can we answer follow-up questions to a metric without diving into the business logic? Looker makes it easy to answer these questions by providing the tools with no coding necessary. Drilling into the Details: Multiple Drill-downs in Looker
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |