Implementing drill-down in a dashboard

From IMSMA Wiki
Revision as of 16:05, 22 June 2017 by Evinek (talk | contribs)
Jump to: navigation, search

What does drill-down refer to?

In the context of data visualisation, "drill-down" refers to moving from one visualisation to another, usually from higher-level information to more detailed data. This is achieved by hyperlinking two visualisations and may involve passing parameters between the two visualisation data sets. Concretely, in MINT this would mean for example that a click on a specific part on a chart in a dashboard leads to another report or dashboard that details the data. As a simple example, one could have a chart representing the number of mine victims by gender. When clicking on either the "male" or the "female" part of the chart, the user would get to another chart, showing for example the number of victims by activity at the time of accident for the chosen category, i.e. male or female.


Drill-down is implemented through the following steps:

  1. Create an Ad-Hoc View with a chart containing a category that should be used for drill-down.
  2. Include that Ad-Hoc View on a dashboard
  3. Create a second Ad-Hoc View that will be the result of the drill-down. This Ad-Hoc View has to have a filter corresponding to the category defined in the first Ad-Hoc View (cf. step 1).
  4. Create a Report based on this second Ad-Hoc View
  5. On the dashboard created in step 2, right-click on the Ad-Hoc-View and select Properties, then go to the Hyperlinks tab. On this tab:
    1. Tick Enable chart links
    2. Under Action, select Open new page in order to open a new page/report/dashboard when drilling down
    3. In Repository URI, insert: repo:/<path_to_your_report>/<name_of_your_report>?<parameter_name>=$P{parameter}