Skip to content

DRILLDOWN RESULT ROWS

Below an example of an output report...

image-20210906115257017

...and of the drilldown report of the first row (complication = "Smart Watch") of that report.

image-20210906115344670

The drilldown report of a given row can help better understand "what is behind" this result row. In this case, Smart Watch sales did particularly well in Steel-Gold and in Bronze Material.

Default all result drilldown

By default, the app will try to generate a drilldown report of each of the five result rows.

image-20210906131947643

It might take time for the app to process all result row drilldowns. Set the "Drilldown all results" widget to False if you do not want to see drilldown reports or you want to choose which report rows to drilldown.

image-20210906132041449

If the app cannot return the drilldown detail of a given row it will display a warning message.

image-20210906125800470

In this case for example given the following report...

image-20210906125951399

...it is not possible to generate a drilldown report of row five, since that result is already fully detailed on all the three dimensions.

Drilldown report

The drilldown report will breakdown a given report row result into a set of sub-components. In this example, the second result above (brand="Ward"), totaling -4.49M, is broken down in four elements.

image-20210906120654164

Drilldown parameters

Open the expander below the "drilldown row" widget of each report row result to fine-tune the drilldown parameters.

image-20210906121052818

For instance, if you do not find the drilldown report above useful, you can try returning an alternative result...

image-20210906121752447

...and you will get a different, alternative but consistent (same -4.49M total), drilldown result.

For example, with three result rows instead of four.

image-20210906121956524

If you do not find this new drilldown detail useful, you can try returning another alternative report...

image-20210906124247635

...that, in this example, provide details of Channel and Customer and still totals (in this case after a -129 balance) to -4.49M.

image-20210906124403397

Moving drilldown result to main report

A "select drilldown rows to move to main report" widget will appear to the right of each drilldown widget.

image-20210906132800537

This allows you to move a result of your drilldown report back into (a modified version) of your main report.

For instance, this is your main report...

image-20210906133319337

...and this is the drilldown report of the first row.

image-20210906133224522

You want to detail your first "material = steel-gold", 6.55M, result row by replacing this row result with - say - the first three rows of the drilldown. Select those three rows (with values of 5.29M, - 2.49M, 2.38M respectively) in the widget and hit submit.

image-20210906133547261

You get a new report. The first 6.55M row has indeed been substituted with the three (5.29M, - 2.49M, 2.38M) results from the drilldown report. The results below might have changed since the sum of these three rows is different from the sum of the original first result.

image-20210906134450153

If you decide to replace the first result row with all 5 of its drilldown components...

image-20210906135151518

..the results below the inserted rows will better - but not necessarily fully - correspond with the original output.

image-20210906135430445