Data and Calculations

Setting up the parameter

The DrillDownTree requires a parameter when configuring the extension. The parameter is needed to store the dashboard-user’s drill down path while working with the extension. To set up this parameter, choose a logical name you will remember and set it to the ‘string’ data type. Leave the current value empty and have ‘All’ under allowable values. If you are using multiple instances of the Drill Down tree in the same workbook, create a parameter for each instance, otherwise they will interfere with each other which might lead to unexpected behaviour. Below is an example of how to set up your DrillDownTree parameter.

Measures

The DrillDownTree allows your dashboard users to drill down on a measure via a path of dimensions they can choose themselves. Select your default measure, and which ones should be available through the measure selector. Measures can be excluded by removing them from the container.

The selected measures will be available through the measure selector in the lower-left corner of the extension. Click the Icon to expand the selector, select the desired measure and see your choice immediately reflected in the visualisation.

Calculations

Using the available measures, custom calculations can be created to allow for even more detailed analysis using DrillDownTree. These are non aggregated calculation as that function as a measure. Click on the pills or on the operators to add them to the text area. The calculation will be added to the measure switcher automatically.