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

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{TOC right}} == What does drill-down refer to? ==__NOEDITSECTION__ In the context of data visualisation, "drill-down" refers to moving from one visualisation to another, usua...")
 
Line 5: Line 5:
  
 
== Principles ==__NOEDITSECTION__
 
== Principles ==__NOEDITSECTION__
 +
Drill-down is implemented through the following steps:
 +
# Create an [[Creating_Ad_Hoc_Views_in_MINT|Ad-Hoc View]] with a chart containing a category that should be used for drill-down.
 +
# Include that Ad-Hoc View on a dashboard
 +
# 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).
 +
# Create a [[Creating_Reports_in_MINT|Report]] based on this second Ad-Hoc View
 +
# 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:
 +
## Tick '''Enable chart links'''
 +
## 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}
  
  
 
== Example ==__NOEDITSECTION__
 
== Example ==__NOEDITSECTION__

Revision as of 16:05, 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}


Example