How to count the time that an issue passed on each option of a configured field?

Catarina Leite

Hello, 

I wanted to track the time that a given issue (or a queue of issues) passed on a given field option on a configured field.

This is, if my configured field options are "a", "b", "c" and "d". I opened the issue with the field selected on "c", then passed 1 hour it was changed to "b", and finally passed 3 hours it was changed back to "c" and the issue was closed 2 hours later.

I wanted to retrieve the summary: c -1 hour, b - 3 hours, c - 2 hours. 

Do you know if it is possible to retrieve this information systematically, without having to go on the activity part fish for that information?

 

Emre Toptancı [OBSS]

Hello @Catarina Leite ,

Jira does not provide this report out-of-the-box but our team at OBSS created Time in Status app and Any Field Report in particular for this exact need.

Time in Status has many report types, mostly to see the time each issue spent on each status, assignee, group, etc.

On top of those, the newly introduced Any Field Report can show you for how long each issue field had each value. Based on your example, for each of your issues you can see for how long the value of your field was "a", for how long it was "b" or "c" etc.

To get this report:

• Install Time in Status by OBSS. ( Timepiece - Time in Status for Jira )
• Open Time in Status screen using the link in the main Jira menu.
• Select your issue usişng the filtering option at the top of the page
• Select Any Field Report as your report type.
• Open the History Fields button menu and select the field you mentioned in your question.

You should be seeing something like this:

Using Time in Status you can also:

• Get averages or sums of those durations (grouped by other issue fields you pick).
• Export your data as CSV, XLS or XLSX.
• Access the same data via REST.

Timepiece - Time in Status for Jira

You can reach our support teams through pluginsupport.obss.com.tr.

EmreT