Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Atlassian Analytics has drilldown functionality that makes it possible to filter charts using other charts. Once set up, you can select an area on a chart to update controls—those controls can be on the current dashboard or a different one. The control then updates any charts that are connected to it. Learn more about controls.
Setting up a drilldown is a two-part process:
Map your chart metrics to controls
Filter your charts with the controls
This is best explained with an example. We’ll start by showing you what the final dashboard looks like, then we’ll explain how to connect everything together.
The bar chart titled Issues created by month is what we’ll call the drilldown chart. Interacting with this chart updates two controls: a “Calendar” and a “Dropdown” control. The controls then update the bar chart titled Issues created by date. This gives us a zoomed-in view of our created issues by project type.
Let’s walk through how to set this up. Let’s say you already have the two charts and two controls on the dashboard:
Issues created by month: A chart grouped by month and project type
Issues created by day: A chart grouped by day and project type
A “Calendar” control named CALENDAR with a data type of Date range
A “Dropdown” control named PROJECT_TYPE containing project types
First, you want to connect the Issues created by month chart to your two controls. This allows your drilldown chart to update the controls whenever you select an area inside the chart.
To do this:
Hover over the drilldown chart.
Select More actions () > Edit settings. This opens the chart settings pop-up.
Go to the Drilldown tab.
For the Linked dashboard, select the dashboard containing the controls that you want to connect the drilldown chart to. In this example, the dashboard is Drilldowns playground. A section to map dashboard variables to drilldown variables will appear.
Select x-value to map to the “Calendar” control. This is because the dates in the drilldown chart are on the x-axis.
Select series to map to the “Dropdown” control. This is because the project types are the series of the drilldown chart.
Select Save.
If your drilldown chart has x- and y-axis labels, you’ll see those labels names instead of “x-value” and “y-value” for the drilldown variables.
Now when you select a specific bar in the drilldown chart, the “Calendar” and “Dropdown” controls will update with the selected date interval and project type.
If you use a line chart or scatter plot chart for your drilldown chart, we recommend increasing the line width or dot size to allow for easier interactions. Learn more about customizing chart settings.
Generally, x-values map to the x-axis, y-values to the y-axis, and series to the columns.
If you’re unsure you’re selecting the correct chart metric to map to your controls, Atlassian Analytics provides sample values below the dropdown for the drilldown variable when you select an option. This makes it easier for you to confirm you’re selecting the right one.
The controls must exist on the linked dashboard.
To link your drilldown chart to another dashboard, select that dashboard for the Linked dashboard. The section to map dashboard variables to drilldown variables will show the dashboard variables that exist in the selected dashboard.
Linking to another dashboard also gives you the option to Pass all variables. If selected, all the current values of the other controls on the drilldown dashboard are passed to your linked dashboard. For this to work properly, the controls on the drilldown dashboard and the linked dashboard must be exactly the same. If the control is not connected directly to the drilldown chart, select No effect for its drilldown variable.
Now that your drilldown chart is set up, you need to connect the “Calendar” and “Dropdown” controls to the Issues created by day chart so it updates when the controls’ values change.
To connect these controls to the chart:
Hover over the Issues created by day chart.
Select More actions () > Edit chart. This will take you to the chart editor.
Let’s assume you use a visual mode query to create the chart. You’ll need to add two filter conditions to the query to connect the chart to the controls:
Project type is one of {PROJECT_TYPE}
Created date between and including {CALENDAR.START} and {CALENDAR.END}
Select to Save to dashboard.
And that’s it! Now you can use your drilldown chart as a control to update other charts.
If you use a table chart as a drilldown chart, the selections are made per-row. If more than one drilldown variable is set up for the chart, selecting a table cell will update all the connected controls.
Additionally, if you connect a table drilldown chart to a multi-select control, you can hold Command and select multiple table rows to add multiple values to your control.
Was this helpful?