Drilldowns are a powerful way to dig deeper into the data and gain immediate insights into the make-up of aggregated information.
For a chart with a Drilldown, double clicking a data point will redirect the user to the target dashboard with filters applied from the value of that data point.
To create the drilldown, click the pencil icon on the source chart.
In the Chart Format tab, open up the Advanced dropdown, and scroll down to the Drilldowns section at the bottom.
First, choose the target dashboard where the drilldown will redirect.
Next, in the left dropdown select the column name of the source chart.
In the right dropdown select the filter name of the target dashboard. In this case, the filter on the target dashboard is called Device. You can learn more about filters here.
The column-filter mapping will only work when the column values of the source chart match the filter values of the target dashboard's filter. In this example, both the column and filter values are taken from
Once the chart is saved, the drilldown is good to go. To drilldown into the data, double click a data point in the chart to be taken to the dashboard populated with the filter values using that data point.
A drilldown-enabled chart can be identified when the cursor changes to a hand while hovering over a data point.
In the Drilldowns section of the Chart Format tab of the chart, choose
None (the first option) for the target dashboard dropdown. This will completely remove the drilldown feature once the chart is saved.
In the Drilldowns section of the Chart Format tab of the chart, click the Delete Mapping link. One or more column to filter mappings can then be deleted from the drilldown. After saving the chart, the drilldown mappings will be removed.
To add a column as part of the drilldown mapping without modifying visual changes to the graph, a column can be included in the SELECT statement of the query while not begin added in the in the Series Settings tab.
The target dashboard can be the same as the source dashboard.
Drilldown mappings will automatically update the dashboard name and filter names.
Column name changes in the source chart will not automatically update in the drilldown mapping.
If multiple columns are mapped to the same filter, the target dashboard will use the values from all columns. If the filter is a radio-button filter, only the first column's value will populate the filter.
In order to correctly map to parent and child filters, the value pair for the parent and child in the source chart must be an existing parent-child value pair in the target dashboard's parent and child filters.
Drilldowns are supported on all chart types except for transposed tables, cohort grids, pivot tables, and number overlays that only return a single value.
Calculate Cumulative, Proportional Bar and Proportional Area, and Pie Charts are valid data points to be used in drilldowns. The generated value will be populated in target dashboard filters.
Rolling Average and Calculate Total in Tooltip are not supported in drilldowns.
Drilldowns are not enabled for shared dashboards. Drilldowns in embedded dashboards are possible through PostMessages. Details can be found in our Embed API Options Documentation.
A drilldown is a mapping between columns of a chart and filters of a target dashboard. In order to create a drilldown the following conditions have to be met: