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

[Shraddha Nalawade]

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.

[Petter Gonçalves · Accepted solution]

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()

3 - Configure that filter to your gadget

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

[Shraddha Nalawade]

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.

[Petter Gonçalves]

You are welcome, @Shraddha Nalawade 

Have a nice day. :)

[Julia Denys [SaaSJet]]

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