Drill down is used to explore a specific dimension or measure of your data and to obtain more details on the next hierarchy levels. In Model View, you can drill down within a visualization into the hierarchies in your dataset.
When drilling down, you automatically apply filters according to the hierarchical field structure of your data, which replaces the parent with the child in the associated drop zone (except when using the Pivot Table, where the child is added to the hierarchy). The filter used for the drill down is added to the Filters panel and the visualization is updated accordingly.
In following examples, various drill down and filtering actions are illustrated:
- To drill down into the next layer of dimensional data, you can click a data
point in a visualization and then select Drill down.
- To drill down into layers of hierarchical data, you can double-click a data
point, axis label, or legend. Note that in cases where more than one hierarchy is
available for drill down, the first available option is automatically selected.
- When a data point has more than one dimension, you can select what dimension
to drill down to from the menu.
In this example, you want to explore motorcycle sales data for the EMEA geography field to analyze the results for each country inside that territory.
- A filter to show the value that was drilled down on is added to the
Filters panel. The chart updates to break down the motorcycles
sales data by ‘COUNTRY’ for the 'EMEA' territory.