Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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 to count the number of times an issue was returned to a specific status.

Edited

We are using the Kanban board template with JIRA Software (Cloud) in a Company Managed proejct.

There is a status called Planning and the workflow allows the issue to return to planning  for additional information, new direction , etc.. 

We would like to have a count of the number of times a the issue was returned to the Planning status individually for each issue.

1) We would like this count to be displayed on the issue card for the specific issue on the Kanban board.

2) We would also like an aggregate total of all the times all the issues in the project have been returned to the Planned status and display this in a new field above he Kanban board.

Any ideas?

 

7 answers

1 accepted

2 votes
Answer accepted

I would suggest that you add a custom number field to the issues to hold this count, and use the Automation feature to increment the number each time an issue makes that transition. You can then build your reports based on that field, and display that field in the Card Layout for the board.

I am not aware of a way you can add to your board a display for the aggregate value of that field for all issues

Hi @Trudy Claspill,

Thank you for your response. I was able to create a custom field and use the automation to update each time the issue was returned to the Planning status per your suggestion.

I have also learned how to sum up the total of all the issues from a video by John Mckiernan but I have not yet figured out how to display the total on the menu at the top of the Kanban board.

Still looking for how to do that.

Thank you for the assistance.

John

Hello @John Ricard 

You can try the third-party add-on that my company provides - Time in Status for Jira Cloud. It generates 7 types of status reports, including Status Count report, that shows how many times an issue has been in each status

statuscount.png

Also, you can export data from the grid to XLSX or CSV file, which you can analyze using such tools as Excel or Google Spreadsheets.

Hope you find it helpful.

Regards, Mariana

Hi @John Ricard ,

With the help of JMWE Cloud app you will be achieve your requirement. Please find below detailed steps.

  • Create a custom field of number field type called "Planning Count" and it to target project screen. Please add it to only view and edit screen of the issues.
  • Add the "Planning Count" field to Board issue detail view.
  • For the transition that leads to planning status, you can add Set Issues Fields ( JMWE) post function and select Planning Count as field with below sample code. Note below example has been shown "Selected for Development" status and you can replace the status name with planning.
    {{ issue | fieldHistory( "status") | filter({to_string: "Selected for Development"}) | length}}
    2021-11-30_23-03-02.png
  • So whenever you make transition to planning status, value will be set with help of JMWE post function.
  • Also please find below screenshot of kanban board.
    Screenshot 2021-11-30 at 10.57.54 PM.png

Thanks,

Avinash

Hi @Avinash Bhagawati _Appfire_,

I did have a look at the JIRA Misc Workflow Extensions (JMWE) I have been able to solve the basic issue without it.  I did not see where it can change the menu on the Kanban board to add the new field that I want. 

Thank you for the suggestion.  Much appreciated. I will keep this in mind for future issue resolutions.

John

Hi @John Ricard 

Given the reporting needs you describe for your use case, you could try a couple of ways to solve this:

  1. investigate marketplace reporting options, or scripting addons to increment a field
  2. add a custom field for the counter, and use an automation rule to increment the field

If you are interested in the automation approach, the rule could be as simple as:

  • trigger: issue transitioned to Planning
  • action: increment the counter

To learn more about automation, please look at this documentation and examples:

Kind regards,
Bill

Hi @Bill Sheboy,

I did find this helpful and I bookmarked some of the pages I had not seen before.

Thanks again

John

Like Bill Sheboy likes this
0 votes
Bloompeak Support Marketplace Partner Jan 02, 2022

Hi @John Ricard,

As an alternative, you can try Status Time Reports app developed by our team. It can display the time spent on specific statuses as well as status entry count.

It provides reports on how much time passed in each status. It has grouping feature so that by grouping statuses(In Progress → In Review → Done) you can get total time. You can also export the report as CSV and open it in excel.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try without installing the app.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

0 votes
Rahul_RVS_Support Marketplace Partner Dec 02, 2021

Hi @John Ricard 

For a readymade solution, to get this data you can try out our app.

Time in Status Reports 

The add-on provides the time in each status for the entire lifecycle of the issue and you can filter by issue type as well. You can also combine your statuses to define your lead/cycle/resolution time and also extract the transitions history of the issues. The main features of the app are as below

  • More than 8 types of Time in Status Reports. Excel Export available for all status reports.
    • Time in Status
    • Time with Assignee
    • Time in Status with Assignee
    • Time with Assignee per Status
    • Status/Assignee Count
    • Multiple Transition Reports
    • Avg Time in status reports
  • Status grouping
  • Save your reports
  • CSV Export
  • Multiple chart types
  • Dashboard Gadget

StatusCount (2).PNG

@John Ricard 

You might want to check out eazyBI app for custom jira reporting.

It can be used to calculate the number of transitions to a historical status and show that for all issues in the board and per issue. Also you can add "Time" dimension to filter transitions in time.

Martins / eazyBI team

example.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

818 views 24 28
Read article

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