It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can i count how many times I moved a story from QA to Work in Progress in Pie Chart Report. Edited

I created one dummy project "Test " and created few stories and bugs. I also created a custom field "Rejected By QA"  which has values {0,1,2,3,4,5}  Every Time a story or bug is rejected by QA  and move back to work in progress, I select a value in increment order. If i moved first time then i will select 1, Second time i will select 2 and so on. The reason  behind doing this is to check how many times i moved stories or bugs in progress and generate reports based on that. However, When i view pie chart reports based on Rejected By QA field it shows me all data including backlog. I only want to view data based on current release version not backlog or any other previous version. How can i generate a pie chart report by filtering release version.

2 answers

1 accepted

0 votes
Answer accepted

Hello @Shraddha Nalawade

Thank you for reaching out.

I understand that you would like to display the issues under the current version of your project in a Pie chart, splitting them based on the number of times the issue was back to the status "work in progress".

The problem you are facing is that all the issues in your project are being displayed in the chart, but you only want the issues in the current version to be displayed. Have I understood it properly?

If that's the case, you can simply create a custom filter to only display the issues of your current version and apply it to the gadget:

1 - Navigate to your issue navigator > Click to switch to JQL

2 - Type and save the following filter, replacing "yourproject" by your project key:

project = yourproject and affectedVersion in unreleasedVersions()

Screen Shot 2019-09-05 at 17.57.51.png

3 - Configure that filter to your gadget

Let me know if this is what you are looking for.

Hi @Petter Gonçalves ,

Thank you for your prompt reply .Yes, I was looking for similar answer. So, instead of Using JQL, I came up with idea of  saving the Basic search filters and using them in generating Pie chart. As, I didn't know how to to use JQL. However, i also liked the way you used JQL. Thanks again for help.

You are welcome, @Shraddha Nalawade 

Have a nice day. :)

Hi @Shraddha Nalawade 

You can also achieve it by using Time in Status for Jira Cloud by SaaSJet.

There you can generate all sorts of reports, e.g. how long your issues has been staying in each status, or how many times an issue went from one status to another, etc. And you can not only view and extract the reports as excel file but also as charts - pie, bar and area charts.

You can try the add-on for free for a month - https://marketplace.atlassian.com/apps/1219732/time-in-status-for-jira-cloud?hosting=cloud&tab=overview

Hope, this is useful for you

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

334 views 1 3
Join discussion

Community Events

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

Events near you