nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reporting

Jerome Salaun_lri8wn

I would like to create a report showing the number of support requests created over a period (weekly), the average response time for these.

Is there a way to create this within Jira, or alternatively get this done by pulling the information into a Gsheet with the Jira Add.on?

Accepted answers

Jack Brickey

Have you looked at the gadgets on Dashboards? You can create filters that reflect the period you wish and then use various gadgets. Here is an article on the various gadgets - using-dashboard-gadgets

Mehmet A _Bloompeak_

Hi @Jerome Salaun ,

Apart from standard gadgets you can check Status Time app developed by our team. One of the reports it provides is average status time. It also takes into account your working hours. That is, once you define your working hours and holidays into the app, then cycle time for a support ticket created on Friday at 5 PM and closed on Monday at 9 AM, will be reported as a few hours rather then 3 days. You can check the online demo and see it in action, e.g you can create average "waiting for support" time of issues grouped by ticket creation week.

Hope it helps.

Emre Toptancı [OBSS]

Hello @Jerome Salaun ,

For a ready built solution that offers great fexibility and details, our team at OBSS built Timepiece - Time in Status for Jira app. It is available for Jira Server, Cloud and Data Center.

Timepiece allows you to see how much time each issue spent on each status. You can combine statuses into consolidated columns to see metrics like Resolution Time, Cycle Time or Lead Time. You can also calculate averages and sums of those durations grouped by issue fields you select. (For example see the average Resolution Time time per project and per issuetype).

Even better, you can have all this data visualized in various chart types.

The app calculates its reports using already existing Jira issue histories so when you install the app, you can get reports on your past issues as well.

The app has Custom calendar support which means you can get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

Using Timepiece - Time in Status for Jira you can:

See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
Export your data as XLS, XLSX or CSV.
Access data via REST API.
Use one of various chart types.

EmreT

All comments

Jack Brickey

Have you looked at the gadgets on Dashboards? You can create filters that reflect the period you wish and then use various gadgets. Here is an article on the various gadgets - using-dashboard-gadgets

Mehmet A _Bloompeak_

Hi @Jerome Salaun ,

Hope it helps.

Emre Toptancı [OBSS]

Hello @Jerome Salaun ,

For a ready built solution that offers great fexibility and details, our team at OBSS built Timepiece - Time in Status for Jira app. It is available for Jira Server, Cloud and Data Center.

Even better, you can have all this data visualized in various chart types.

The app calculates its reports using already existing Jira issue histories so when you install the app, you can get reports on your past issues as well.

Using Timepiece - Time in Status for Jira you can:

See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
Export your data as XLS, XLSX or CSV.
Access data via REST API.
Use one of various chart types.

EmreT

Zoryana Bohutska _SaaSJet_

Hi @Jerome Salaun

As you can see there are many tools, but also you can consider Time in Status for Jira Cloud app by SaaSJet.

Here some screens show how to get the data you need.

1. Using time in status report you can select the date range you need, to see created issues (with each status duration data)

2. Choose average time report + chart view - and you will get the average time that issues spend in each status.

Hope it helps

Regards

Sai_ManageEngine_AnalyticsPlus

Hello Jerome Salaun,

Have you tried the Analytics Plus app for Jira Software? It's an IT analytics application using which you can create dashboards to view the time spent by issues in each status.

If you're looking for a ready-to-use solution, reports that you can start using it as soon as you install the app. The app comes with an AI-assistant. So, if you need to see a report, just speak and let the AI-assistant build your report for you.

Jira artboard.png

With the Analytics Plus app, you can

Gain insight into multi-project metrics such as time in status and more.
Calculate the age of issues and view the history of users who've worked on them.
View the complete history of projects on a single dashboard.
Create several reports or dashboards over critical project KPIs.
Share reports or dashboards securely with your team.

Disclaimer: I'm a product expert for Analytics Plus app.

https://marketplace.atlassian.com/apps/1223951

Mike Singleton_is5o1n

So in essence not w/o a plugin. My fav is EazyBI.. does the work of ten plugins

Miles Roberts

Hello, do you know if this can be used with Trello or do you know of an alternative system that can report how long a card takes to progress through different stages?

Emre Toptancı [OBSS]

Hello Miles,

Trello is a completely separate system and our app doesn't support Trello.

I'm sorry but I don't know much about Trello-specific solutions so I don't have a recommendation there.

EmreT

Sami Linnanvuo _Screenful__q6qbo3

@Miles Roberts for tracking timings in Trello, I suggest taking a look at the Screenful Power-Up. You can learn more about its timing features from this Tour page.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-desk

jira-service-desk-cloud