Difference between revisions of "Implementing drill-down in a dashboard"

From IMSMA Wiki
Jump to: navigation, search
Line 14: Line 14:
 
## Under '''Action''', select '''Open new page''' in order to open a new page/report/dashboard when drilling down
 
## Under '''Action''', select '''Open new page''' in order to open a new page/report/dashboard when drilling down
 
## In Repository URI, insert: repo:/<path_to_your_report>/<name_of_your_report>?<parameter_name>=$P{parameter}
 
## In Repository URI, insert: repo:/<path_to_your_report>/<name_of_your_report>?<parameter_name>=$P{parameter}
 +
## The parameter mapping will be created automatically.
  
 +
{{Note|It is a bit tricky to find out the exact parameter name. Refer to the example below for a trick on how to determine the exact name.}}
  
 
== Example ==__NOEDITSECTION__
 
== Example ==__NOEDITSECTION__

Revision as of 16:36, 22 June 2017

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.

Principles

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}
    4. The parameter mapping will be created automatically.
Note.jpg It is a bit tricky to find out the exact parameter name. Refer to the example below for a trick on how to determine the exact name.

Example