Drilldown capabilities using controls

[Broussard, Anna]

I am using a chart template from Atlassian Analytics, Issues created vs resolved. It works as expected... I get a bar chart that shows how many issues are created and resolved in separate bars by week. I want to click on any bar on the chart to see the actual issues list that composed the bar. I created a dashboard control (DRILLDOWN_RANGE) with a date range type and specified the x-value to use for the dashboard control so that when I click on the bar, say for Feb10-16, I get the range saved to the dashboard control.

I have another chart on the same dashboard where I have a list of issue details in my project, filtering on the date range in my dashboard control (DRILLDOWN_RANGE). When I click on issues created bar on my first chart (created vs resolved), I get all issues in the date range (both created and resolved) in my issues list, even though I just want the issues created. 

How do I create a filter or variable I can pass from my issues created vs resolved bar chart to not just filter on the dates, but also to distinguish between issues created vs resolved in my issues list. 

Another problem is that the drill down doesn't seem to adhere to the date range from the control... it sometimes shows issues that are a day later than the week range.

[Jesse Klein · Accepted solution]

Hello!

Thanks for the question about drilldowns and setting it up to only show issues created instead of both created and resolved. I tried this in a test instance and I think it is dependent on changing the drilldown settings of the chart to use "series" instead of the x-value. When I do this, I am able to click on the issues and it only shows the created issues instead of keeping both. I would give that a try to see if that solves the issue.

For this and the issue with the date showing incorrectly, I recommend opening a support ticket with us. It'd help us see your specific data and identify why the dates are showing as a bit off from what you're expecting. It's hard to tell in just text. Please go to support.atlassian.com to open a ticket. Thanks for your time!

Regards,
Jesse

[Broussard, Anna]

Hi Jesse, thanks for the suggestion! To make the drilldown work across both time filter and created/resolved, I did have to end up using 2 controls, x-value for time and series for created vs resolved.