The Drill Down is a powerful features that allows you to explore your data. Use this feature to answer two different needs:
- decompose an "aggregated" value on different dimensions.
- in the case of block computed with a formula, decompose the formula to understand where the data comes from and and the calculation steps.
How to access Drill Down?
Right click on the metric value you want to understand and choose Drill Down.
Use Drill Down
Here is the Drill Down windows:
It is made of 4 different sections:
- the Drill Cell context: reminds you what was the value of the cell on which you started the Drill down.
- the Drilled block formula: display the formula of the metric on which you did the Drill through.
- the Formula tree navigation: decompose the formula in different calculation steps and represented in a tree.
- the View on block: Display the data of the element selected in the Formula tree nav.
Drill Down aggregated data:
By default the first view displayed will show a view which details all dimensions which where aggregated. This way, you can understand how each value contribution to the aggregated number. As on any other views in Pigment, you can adjust the view with all standard view feature (Filter , sort, totals, formatting etc...).
Drilling down to more granular data is a good thing, but if the data is computed thanks to a formula, you may need to go further and understand how this figure has been computed.
Drill down the formula:
The Navigation tree represent the different calculation step we do to evaluate the formula. Expand/Collapse the different nodes to have more details.
If you select a new node, the corresponding part of the formula will be highlighted in the formula bar.
When you navigate from one tree element to the other, page selectors will be automatically adjusted by our engine to display all values which contributed to the result.
Some Tree element are disabled, what happened ?
You may see some sometime this tooltip:
The reason is because for the formula scoped you drilled from, there is no way this part of the formula feed the end data. It mostly comes from Dimensions modifier like
[Select: Dimension."item"] .
You may see sometime this tooltip:
The reason either because the formula you analyze uses an unsupported function or because you are using filters/dimensions modifiers which cannot be expressed as Page selector in the view.
Not supported function :
Not supported filter/dimension modifier:
- Filters on metric values
- Select which does Offset
Use Drill Down by
The Drill Down by feature is the same as the Drill Down with a small difference, before opening the Drill Down windows, select Dimensions on which you want to Drill Down. Then the default first view will split the data only according to those selected dimensions.