Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Calculate Number of times particular status visited

Amjath k
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 6, 2020

Is there a possibility of calculating (with jql query) a number which defines how many times a particular status present in the ticket.

For example:

we have 5 tickets where workflow has status - "to tester". Each ticket went to tester and one ticket went back to developer by tester. so, count would be 6 for this ticket.

3 comments

Comment

Log in or Sign up to comment
Andrew Laden
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2020

Can do it using a field to count the transitions.

Create a custom field that is a number.

Add a post function (or automation rule) an any transition to the status that adds 1 to that field.

Also look at some previous discussions

https://community.atlassian.com/t5/Jira-questions/How-can-I-count-number-of-times-an-issue-was-in-each-status/qaq-p/793672

Zoryana Bohutska _SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 11, 2020

Hi @Amjath k 

Also, you can get the number of times particular was status visited using add-on Time in status for Jira Cloud.

Its report Status Count will give you the data you need. You can view it as issue list or as charts and export them.

2020-03-02_20-43-58.png

Mehmet A _Bloompeak_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 26, 2020

Hi @Amjath k ,

You can use Status Time add-on. It generates status count report in addition to status time report.
StatusCount.gif

TAGS
AUG Leaders

Atlassian Community Events