Report Showing quantity of a status

[Brad Schultz]

Our design team uses a Status "Preflight" and I am trying to create a report showing how many times an issue has been placed into that Status.  One issue could have been in that status several times in just one day.  Would like to create a report showing the amount of issues using that status.  

[Bill Sheboy]

Hi @Brad Schultz 

Short answer: there is no built-in way to count those, although there are several workarounds possible depending upon your frequency of need and willingness to spend money / time.

On to the workarounds:

• need one time for one work item
  • look at the changelog / history for the work item and count them
• need often, and have money to spend
  • investigate marketplace apps to help visualize / report on the changelogs
• need often, and have time but no money to spend
  • There is a REST API endpoint to get the change logs, but uses paging of up to 100 change entries.  And so if a work item changes often, getting the information is challenging.  Some workarounds for that are...
    • Build an automation rule inside of Jira, triggered on transitioning a work item to that status, and increment a counter in a custom field
    • Assume there are fewer than 100 work item changes, and use an automation rule to call the REST API and count what you find for the status transitions
    • Build an automation rule in Jira which uses recursion to read the change log with the REST API (paging as needed) and perform the counts.  This is risky as the looping service limit could halt the rules for the site.
    • Build an app outside of Jira which can call the REST API and handle paging to perform the counts

Kind regards,
Bill