Implementing drill-down in a dashboard - Revision history

Alnaucler at 19:12, 20 February 2020

2020-02-20T19:12:58Z

← Older revision		Revision as of 21:12, 20 February 2020
Line 44:		Line 44:
	</ol>		</ol>

	{{NavBox ~~Business Intelligence~~}}		{{NavBox Hub}}
	[[Category:~~VIE~~]]		[[Category:NoPublic]]

Evinek at 13:15, 22 June 2018

2018-06-22T13:15:40Z

← Older revision		Revision as of 15:15, 22 June 2018
Line 43:		Line 43:
	<li>Run the dashboard and click on different values (Male/Female) of your chart to experience the drill-down.</li>		<li>Run the dashboard and click on different values (Male/Female) of your chart to experience the drill-down.</li>
	</ol>		</ol>

			{{NavBox Business Intelligence}}
			[[Category:VIE]]

Evinek at 15:17, 22 June 2017

2017-06-22T15:17:36Z

← Older revision		Revision as of 17:17, 22 June 2017
Line 20:		Line 20:
	== Example ==__NOEDITSECTION__		== Example ==__NOEDITSECTION__
	Let's walk through a concrete example to illustrate the principle described above. For this, it is assumed to have a [[Creating_MINT_Domains\|Domain]] on Victim data from IMSMA.		Let's walk through a concrete example to illustrate the principle described above. For this, it is assumed to have a [[Creating_MINT_Domains\|Domain]] on Victim data from IMSMA.
	# Create a new dashboard		<ol>
	# On this dashboard, create a new chart dashlet (new content):		<li>Create a new dashboard</li>
	## Base it on a Victim data domain		<li>On this dashboard, create a new chart dashlet (new content):</li>
	## Create a very simple bar or pie chart to visualise the number of victims by gender		<ol>
	## Save the dashlet and the dashboard		<li>Base it on a Victim data domain</li>
	# Create another simple Ad-Hoc View on the same domain to visualise the number of victims by activity at the time of accident (or by any other activity). Create a filter on Gender. Save as ad-hoc view and report and remember the name and location of the report.		<li>Create a very simple bar or pie chart to visualise the number of victims by gender</li>
	# Go back to the dashboard created in the previous step		<li>Save the dashlet and the dashboard</li>
	# Right-click on the victims by gender chart and select Properties		</ol>
	# Go to the '''Hyperlinks''' tab		<li>Create another simple Ad-Hoc View on the same domain to visualise the number of victims by activity at the time of accident (or by any other activity). Create a filter on Gender. Save as ad-hoc view and report and remember the name and location of the report.</li>
	# Tick '''Enable chart links'''		<li>Go back to the dashboard created in the previous step</li>
	# Under '''Action''', select '''Open new page'''		<li>Right-click on the victims by gender chart and select Properties</li>
	# In '''Repository URI''', insert: repo:/<path_to_your _report>/<name_of_your_report>?genderenum_enum_1=$P{Gender}		<li>Go to the '''Hyperlinks''' tab</li>
	## '''repo:''' means that the linked report is a resource from the MINT repository		<li>Tick '''Enable chart links'''</li>
	## To determine the name of the parameter (in this case genderenum_enum_1), go to the drill-down Ad-Hoc View and hover over the filter attribute, in this case '''Gender''' and note the name appearing in the popup, such as ''genderenum_enum'' in the example below. Then, append '''_1''' to this name to get the full parameter name, in this case ''genderenum_enum_1''.		<li>Under '''Action''', select '''Open new page'''</li>
	[[File:MINT_drilldown_parameter_popup.png\|center]]		<li>In '''Repository URI''', insert: repo:/<path_to_your _report>/<name_of_your_report>?genderenum_enum_1=$P{Gender}</li>
	# Save the dashboard		<ol>
	# Run the dashboard and click on different values (Male/Female) of your chart to experience the drill-down.		<li>'''repo:''' means that the linked report is a resource from the MINT repository</li>
			<li>To determine the name of the parameter (in this case genderenum_enum_1), go to the drill-down Ad-Hoc View and hover over the filter attribute, in this case '''Gender''' and note the name appearing in the popup, such as ''genderenum_enum'' in the example below. Then, append '''_1''' to this name to get the full parameter name, in this case ''genderenum_enum_1''.
			[[File:MINT_drilldown_parameter_popup.png\|center]]</li>
			</ol>
			<li>Save the dashboard.</li>
			<li>Run the dashboard and click on different values (Male/Female) of your chart to experience the drill-down.</li>
			</ol>

Evinek at 15:14, 22 June 2017

2017-06-22T15:14:40Z

← Older revision		Revision as of 17:14, 22 June 2017
Line 19:		Line 19:

	== Example ==__NOEDITSECTION__		== Example ==__NOEDITSECTION__
			Let's walk through a concrete example to illustrate the principle described above. For this, it is assumed to have a [[Creating_MINT_Domains\|Domain]] on Victim data from IMSMA.
			# Create a new dashboard
			# On this dashboard, create a new chart dashlet (new content):
			## Base it on a Victim data domain
			## Create a very simple bar or pie chart to visualise the number of victims by gender
			## Save the dashlet and the dashboard
			# Create another simple Ad-Hoc View on the same domain to visualise the number of victims by activity at the time of accident (or by any other activity). Create a filter on Gender. Save as ad-hoc view and report and remember the name and location of the report.
			# Go back to the dashboard created in the previous step
			# Right-click on the victims by gender chart and select Properties
			# Go to the '''Hyperlinks''' tab
			# Tick '''Enable chart links'''
			# Under '''Action''', select '''Open new page'''
			# In '''Repository URI''', insert: repo:/<path_to_your _report>/<name_of_your_report>?genderenum_enum_1=$P{Gender}
			## '''repo:''' means that the linked report is a resource from the MINT repository
			## To determine the name of the parameter (in this case genderenum_enum_1), go to the drill-down Ad-Hoc View and hover over the filter attribute, in this case '''Gender''' and note the name appearing in the popup, such as ''genderenum_enum'' in the example below. Then, append '''_1''' to this name to get the full parameter name, in this case ''genderenum_enum_1''.
			[[File:MINT_drilldown_parameter_popup.png\|center]]
			# Save the dashboard
			# Run the dashboard and click on different values (Male/Female) of your chart to experience the drill-down.

Evinek at 14:36, 22 June 2017

2017-06-22T14:36:28Z

← Older revision		Revision as of 16:36, 22 June 2017
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__

Evinek at 14:05, 22 June 2017

2017-06-22T14:05:21Z

← Older revision		Revision as of 16:05, 22 June 2017
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__

Evinek: 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..."

2017-06-22T13:50:36Z

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..."

New page

{{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, 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 ==__NOEDITSECTION__

== Example ==__NOEDITSECTION__