Using a 2D stacked bar chart where the source captures the data from the correct project & excludes cancelled issues. The group by uses status category. The x-axis labels separate the data into Fix versions. So far, so good.
What is happening is that it returns the current status category, but what I really want is the status category at a point in time i.e. the end of Sunday, 11-22-2020.
source jql = project = "LPUK Epic Repository" AND NOT status in (Cancelled)
X-Axis jql = fixVersion WAS "LPUK Q4 - 2020 Release" ON 2020-11-22.
I can get the fix version based on point in time, but because the grouping is based on status category & the x-axis is only based on one fix version, I can't seem to separate the status category issue count for each status category. Every way I've tried this I get a jql error.
Hi @david_hirst ,
Thank you for posting this question. I can see what you are trying to achieve and while I don't think this is currently possible in a single chart, you could achieve this by creating multiple charts, one per release.
The WAS and WAS IN operators are provided by Atlassian JQL and from their documentation it shows that only Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields are currently supported.
Therefore, if you made a chart that was just for a single release, you could have both Chart By and Group By set to Custom JQL and write something like:
Your request is something we are currently looking at as a built-in feature to simplify this process. I will let you know when we have an update for you.
If you have any other questions you can contact our team directly at: https://ossapps.atlassian.net/servicedesk/customer/portals
Tom - Custom Charts Support Team
Thanks again for your super quick reply & detail.
I thought it was my Jira ineptitude showing up again, but good to know I wasn't going totally mad.
I had already made this second graph which works exactly as you've suggested, so again good to know that is a sensible approach. As the two aren't synchronized at a point in time, I've moved them around on the page to make them work better for now, so look forward to hearing if this becomes a feature in future.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events