A Drilldown can refer to a variety of operations, but it usually means moving from summary to detailed information. Create Drilldowns in dashboards to look deeper into your data and get down into particular data points; you could look at blog performance for specific blog post or dive into the activity of a specific blog post.
In this example, we create a chart showing the number of new contacts by the campaign that brought them in for each month. We’ll have a Drilldown that selects for the contacts brought in by a particular campaign ID and drills down into each day of that selected month. This is useful because if you see a spike of activity, you can drill down into a daily view of that specific campaign and figure out what happened.
First, establish what dashboard variables you will use to create the dashboard. We want to drill down by time and campaign. Create a Calendar variable to filter by time, and a Dropdown variable to select the campaign ID.
a. Calendar Control:
b. Dropdown Control (Note: Click Run Query in order to view and edit the dropdown settings in the right-side preview):
Create a chart that shows the number of contacts by month and has four layers for each Campaign ID. This will be the chart that we select a bar to drill down into and display more detail.
a. From the Marketing tab, drag Id into the Measures field and Created Date into the Dimensions tab. Change the column’s Time Bucket to Month of. Also drag Campaign Id into the Dimensions field underneath the Created Date.
b. Drag Campaign Id into the Filters field and type AW, FB, TV, and MW into separate Terms by clicking +Add. Click Ok.
c. In the Pipeline, click on +Add Transformation and choose Pivot Data. Sort the columns Ascending and count with a SUM.
Create another chart that shows the number of contacts by day and is being filtered by the Campaign ID and the date. This is the chart that will show the Drilldown after selecting from the first chart. This chart will not display a preview yet as we haven’t selected a value for the Controls.
a. From the Marketing tab, drag Id into the Measures field and Created Date into the Dimensions field.
b. Add Campaign Id and Created Date into the Filters field. For Created Date, change the range to between and including and use the dropdown menu to choose
Note: Even though this chart is not currently displaying anything, remember to change the chart type to Bar.
- Hover over the layered bar chart you just created and click Edit Settings from the ellipsis menu. Under the Drilldown tab, choose the dashboard you are currently working on and link the Controls to the Drilldown.
Now open the settings for the other chart that’s currently not displaying anything. Again, link the current dashboard to the Drilldown and connect the Controls.
To change the Drilldown chart, you can now change either of the two Controls placed above the charts or click on the layered chart.
See our video below for another example of setting up a Drilldown between two charts:
Hidden Variables in the Drilldown
From your dashboard, click the gear icon, and in the settings menu, select the Variables tab from the menu.
Click your Hidden Variable to expand its settings. Select the Can Drilldown checkbox.
Now when you set Drilldown variables in your charts, you should see your Hidden Variable listed as an option.