How to read [Chart] Time in Status ?

Kishan Borad

I was going through different options to extract the report on how many times(in numbers) a task was in Peer review and what was the duration(in hours) it was in peer review for each time.
And I came across this term [Chart] Time in Status, and I tried generating report based on this option.
But the format in which the data populated was not human readable.

 Eg. 10007_*:*_1_*:*_93158_*|*_3_*:*_2_*:*_622625_*|*_5_*:*_1_*:*_0_*|*_10041_*:*_1_*:*_434801_*|*_10000_*:*_1_*:*_1832499_*|*_10011_*:*_2_*:*_847873_*|*_10012_*:*_1_*:*_56972_*|*_10006_*:*_1_*:*_988603

 

Does any know how I can read this data?

I am thanking you in Advance.

Mehmet A _Bloompeak_

Hi @Kishan Borad , Welcome to the Community!

The field stores all statuses an issue has been. Statuses are separated by "_*|*_".

Inside each status there is status id, number of status entry and time in seconds in that status.

So your below input means:

10007_*:*_1_*:*_93158_*|*_3_*:*_2_*:*_622625

Issue has been in:

• status with id 10007, 1 time for 93158 seconds
• status with id 3, 2 times for 622625 seconds

 

Built-in Jira reports and gadgets offer limited flexibility for time in status. If you prefer using a marketplace app for this, you can try Status Time Reports app developed by our team which is available for Jira Server/Data Center/Cloud. It mainly provides reports and gadgets based on how much time passed in each status.

• You can select issue fields and statuses that you want to see in your report. It has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).
• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to theworking calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

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.

Note: If you are interested in cycle and lead time, you can have a look at the article below.

Cycle Time and Lead Time in Jira: Productivity Measurement with Two Critical Parameters

Hope it helps.