A Drill Down can refer to a variety of operations, but it usually means moving from summary to detailed information. Create Drill Downs 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 are creating a chart that shows the number of new contacts by the campaign that brought them in for each month. We will have a Drill Down 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 variable:
b. Dropdown variable (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 Drill Down after selecting from the first chart. This chart will not display a preview yet as we haven’t selected a value for the variables.
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 variables to the Drill Down.
Now open the settings for the other chart that’s currently not displaying anything. Again, link the current dashboard to the Drill Down and connect the variables.
Now you can change either of the two variables hovering above the charts or click on the layered chart to change the Drill Down chart.
See our video below for another example of setting up a Drill Down 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.