Need to calculate average days of issue types completion

Question

Hello,

We need to create report which shows average number of days to take the completion of all the issue types based on the custom field value from work type 1 and work type 3

Ex: We have 10 work types and work type 1 will be linked with all other 9 work types. and work type 1 will have custom field which shows Yes or No. and work type 3 custom field will have Low, Medium and High category

Low Category tickets

1st Cycle

Work type 1 with custom field value = Yes and took 2 days to complete

Work type 2 will link with work type 1 and took 2 days to complete

Work type 3 will be link with work type 1 and custom field value = Low Category and took 1 day to complete

Work type 4 will link with work type 1 and took 2 days to complete

Work type 5 will link with work type 1 and took 4 days to complete

Work type 6 will link with work type 1 and took 1 day to complete

Work type 7 will link with work type 1 and took 1 day to complete

Work type 8 will link with work type 1 and took 2 days to complete

Work type 9 will link with work type 1 and took 3 days to complete

Work type 10 will link with work type 1 and took 1 day to complete

Now total days from work type 1 to work type 10 ticket took = 19 days.

Similarly, this cycle is repeated, and we want to calculate the average.

1st cycle = 19 days, 2nd cycle = 20 days and 3rd cycle = 15 days and the average days to complete is = 18 days.

Our report should display average days to complete the Low category tickets.

Similarly same cycles will repeat for Medium category tickets and High category tickets.

We are ok to create 3 different reports which shows average days for Low , Medium and High Category tickets.

Is there any way that we can achieve this in Jira cloud. without support of any plugins.

or any plugin will us to complete this report.

Thanks,

Prathap DL

Melisa Mutlu (OBSS) · Answer

Hello @PLaksh11

You can generate the report you’re looking for using our Timepiece - Time in Status for Jira app. In particular, the “Duration between status” report will help you achieve results that closely match your needs.

With DBS reports, you can simply measure cycle time. This makes it a strong fit for your needs. Additionally, the Timepiece app offers grouping capabilities, so you can group your issues by parent key and work type 3.

You can review the example I prepared for this case below.

If you’re interested, you can book a demo session with our product specialists and go through your use case together.

You can find Timepiece - Time in Status for Jira on the Atlassian Marketplace.

Full disclosure:
I’m part of the team that develops Timepiece.
Melisa

Danut M _StonikByte_ · Answer

Hi @PLaksh11,

This appears to be a highly customized report that isn’t available through Jira’s built-in reports or gadgets.

By “cycles,” I assume you’re referring to the workflow statuses and the time spent by the issues in each statuses.

As mentioned earlier, one potential solution is to search the Atlassian Marketplace for a plugin that can generate this type of report.

If you’re considering trying a plugin, I recommend taking a look at the Time in Status gadget available in our Great Gadgets app.

This gadget can calculate the average time spent in each workflow status, as well as the overall time to resolution for issues within a filter or JQL. Additionally, it supports grouping data by a custom field, allowing you to visualize the average time for each category (e.g., Low, Medium, High), as shown in your example.

Or, by issue types:

On its Data tab, the gadget displays the issues along with the time in every status. You can export this data in CSV for further processing.

Hope this helps.

Danut.

Khrystyna_Dzhus_SaaSJet_ · Answer

Hi @PLaksh11 ,

This is very difficult to do using standard Jira tools (you need to create a bunch of complex automation rules and additional fields).

I suggest trying the marketplace add-on Time in Status by SaaSJet (developed by my team), which can help with your use case.

It provides an Average Time report that shows the average time work items have been staying in statuses during a specific period. You will need to choose JQL (e.g., Work Type 1 = Yes, Work Type 3 = Low) or Filter for that report.

The report will generate an average time spent in statuses for selected issues.

You’ll be able to create separate reports for:

Low

Medium

High

Additionally, you can add this report to the dashboard using the Accurate Time in Status gadget.

If you have any questions, do let me know.

Hope you find it useful!