Hello! I have grouped several statuses in JIRA into bigger buckets - i.e. the "Open" bucket includes Open, Request for Info, Reopened, Monitoring, Blocked; and "Closed" includes Closed, Verified and Resolved.
Project = "Testing" and Status in (Open, Request for Info, Reopened, Monitoring, Blocked)
Project = "Testing" and Status in (Closed, Verified and Resolved)
Project = "Testing" and Status in ("In Progress")
I'd now like to display a simple pie chart that shows the total number in each of those three JQL queries in one chart - i.e. if 10 are open, 5 in closed, and 5 in progress by the above definitions, a simple 10,5,5 pie chart is shown.
I can't find a way to do this, although it seems simple.
Hopefully someone has the answer!
Thanks in advance.
I also thought this would be a useful feature that doesn't come out-of-the-box with Jira, so we recently added it to our app Custom Charts for Jira.
This is a simple to use pie charting app that allows you to customise the colors, change the order, and group options together.
You can test the app out right now on our free interactive playground: https://www.oldstreetsolutions.com/custom-charts-for-jira
In the next release, we'll be releasing a feature so you can also rename grouped segments e.g. (Open, Request for Info, Reopened, Monitoring, Blocked) to "Open".
We have plans for a number of other chart types, including bar charts and funnel charts.
I hope this provides a solution to your problem. If you have any suggestions of how we could improve the app I'd love to hear them :)
Custom Charts Product Manager
Really interesting question, made me thinking. I don't think this is possible without using any add-on.
To solve this problem what I would do is update one additional field (I like using labels) for these statuses (whenever the transitions as done to them) and use that field in the pie chart. Now how you update this new field is another requirement, either update it manually or use a scripted post function (if you have ScriptRunner).
What do you think?
Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...
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