Drilldown chart

Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 19, 2024

Hi all,

Is there an example chart or dashboard that shows how to do a drilldown chart? I have a heat map chart that shows created issues per hour and wanted to see if it would be possible to click on a number in that chart that would update an issue list chart that would show the requests that as created during the selected date/hour.

Screenshot 2024-02-19 at 3.30.43 PM.png

So for example if I clicked on the 2 at 04 Feb 19 it would show just those two requests in the list view.

2 answers

0 votes
Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 22, 2024

Hi Mikael,

This article walks through an example of setting up drilldown between two charts: https://support.atlassian.com/analytics/docs/use-charts-as-variable-controls/

Additionally, if you use the "Jira Software - Overview" dashboard template, there is drilldown set up between the "Top 5 projects by issue count" and the "Issue details" table chart on the bottom, so you can use this as an example.

Based on the heat map in your screenshot, you can pass the date (e.g. Feb 18) and hour (e.g. 02) values to variable controls that are then used to filter your table chart. This means the table chart needs to have the controls connected to filter on these as well. 

Let me know if this helps or if you have further questions! 

0 votes
Björn Eriksson February 20, 2024

Hi
I need to start in the beginning :-)

How do you create that heat map chart?

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 22, 2024

Hi Björn,

This video could be a good starting point on how to create a basic chart in Atlassian Analytics: https://www.youtube.com/watch?v=sWdmrUfqoQw&list=PLaD4FvsFdarRVuaVKCAg2hZqCe-rtxMe2&index=7&pp=iAQB  

Feel free to browse the other videos in the playlist, as well as our documentation on heat map charts.

Ganesan Seethapathy July 3, 2024

Hi

 

How to open a Drilldown chart in a new tab /window instead of redirecting in the same tab, we are losing the original chart and it is time consuming to reload / go back to the original chart. 

Please guide me

 

Thanks !

Ganesan Seethapathy August 2, 2024

Hi 

 

Is it possible to set Variables or pass discreet values to the drilldown report

 

Detail:

From the main dashboard, i would like to pass values from controls (like dropdown) or discreet values, other than x value / y value from the report to the "Drilldown" report. 

Please guide me on how to achieve this

 

Thanks

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 5, 2024

HI @Ganesan Seethapathy,

It looks like you got your first question answered here: https://community.atlassian.com/t5/Atlassian-Analytics-questions/Drilldown-Chart-in-a-new-Window-Tab/qaq-p/2746085 

For your second question, that is not currently possible. The drilldown functionality can only use visible values (such as the x-axis/y-axis) from a chart.

Ganesan Seethapathy August 6, 2024

Hi Tracy 

 

Thank you for the response.

But in the Main dashboard /report, if we use any filter or selection criteria to build it, that also supposed to pass on as part of inputs to the drill down report. 

Could you please take this as a requirement for future release ?

Thanks

Ganesan Seethapathy August 20, 2024

Hi 

 

Appreciate if you could confirm whether any approach/ plan from Atlassian, towards passing additional values/ criteria to the Drilldown Report

 

There are 2 scenarios ,where i'm stuck right now on this issue.

Scenario 1: In the main report, if we have multiple controls to filter the report but the drilldown pass only the values  of x and y axis.  Unable to pass the control values to the drill down report

 

Scenario 2: The Main dashboard have multiple reports  , with different Attributes driven such as "Department /Team based", "Under Different Levers from JIRA like Business Driver, Member Impact" - which are not being x/ y axis values.  We need to pass these values to the drilldown report to show the appropriate (drilldown) data 

 

Thanks

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 20, 2024

Hi @Ganesan Seethapathy, we appreciate the feedback and information about your use case.

I have created a feature request on your behalf for this functionality: https://jira.atlassian.com/browse/ANALYTICS-304. This is not currently on the upcoming roadmap, but I suggest voting on and watching the ticket for updates. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events