Search Results

Drilling to details

When you want to drill down into specific data in a visualization, a details visualization can be created. The data, for which detailed information is wanted, is selected through marking, and the created details visualization is then based solely on the marked data.

The map chart below is used to illustrate. The markers represent the total sum of sales at two different stores after the first six months of 2017. However, the data table on which the map chart is based contains more information, so it is possible to drill down into details. Assume, for example, you are interested in displaying the monthly sales at the Boston store.
Details visualization image 1
This can be done by creating a details visualization. The line chart below is such a visualization, but any visualization type can be created. By marking the Boston marker in the map chart, the monthly sums for the Boston store appear in the line chart.
Details visualization image 2
Note: The Data limiting setting in the legend states that the data in the created details visualization is limited. The line chart above displays only data that is marked in the map chart using this particular marking.

Details visualizations can be used to drill down into your data in multiple steps. The marking you perform in one visualization determines what you will see in the next visualization, and so on.

Prerequisites

The visualization where you want to drill down into details is created.

Procedure

  1. Mark the items on which you want to base the details visualization.
  2. Right-click the visualization, select Create details visualization and the visualization type to use as details visualization.
    A suggestion of the selected visualization type is presented. It is based on the marked data only.
  3. Adjust the details visualization according to your needs. For information on how to adjust visualizations, see Creating a visualization.

If you want to drill down deeper and deeper into your data, you can create consecutive details visualizations.

  1. Repeat steps 1-3 with the details visualization as starting point.