Need to calculate average days of issue types completion

[PLaksh11]

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

1^st 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.

1^st cycle = 19 days, 2^nd cycle = 20 days and 3^rd 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

[Rahul_RVS]

Hi @PLaksh11 

If you would like to try out a mktplace app for this requirement, pls explore

Time in Status Reports 

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. 

With Status grouping feature, can help you define your own cycle time / issue age time and view the averages of the same. Also the app has 20+ reports to meet a variety of use cases.

You can set your own working calendar to exclude weekends and holidays from the time in status calculation.

More details here.

Disclaimer : I am part of the app team for this add-on 

[Danut M _StonikByte_]

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_]

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!

[John Funk]

Hi @PLaksh11 

I suggest you try one of the many third party apps in the Atlassian Marketplace for Time In Status reports. Some are even free. 

https://marketplace.atlassian.com/search?query=Time+in+Status&hosting=cloud

[Bill Sheboy]

Hi @PLaksh11 

How you choose to solve this reporting depends upon a several things:

• what you mean by "days to complete" a work item,
• the complexity of what to include (relative to the linking and field values), and
• how often you need this report.

Let's assume for "days to complete" you mean: the number of days from work item Created until Resolved. 

Regarding the frequency of usage / reporting and complexity:

• When you need this one time
  • Try exporting the relevant fields to a spreadsheet, then use spreadsheet functions / features to perform the necessary calculations for reporting
• When you need this more often
  • Consider investigating either the Atlassian Marketplace for advanced reporting apps, or export your relevant Jira work items to a reporting database which is capable of doing this type of reporting

It is likely if you wait a few hours / days, multiple vendors will post suggestions of marketplace apps to try :^)

Kind regards,
Bill