Is it possible to get the average time to resolution issue statistics of yesterday in the dashboard?

Question

Is it possible to get the average time to resolution statistics of yesterday's service project in the dashboard? The shortest now is 48 hours, but we must have an average of one day because we must follow our KPI day-to-day basis. Yes, we get a lot of requests during the day.

I know it is possible to do these under service project reports to set the custom time range to one day, but it is not very convenient to do every day.

Maybe there is some workaround, some other way?

Disclaimer: currently we are still working with our old help desk and we do not have requests on the Jira service desk yet, but we are preparing for the future.

Marc Isikoff_o8qjap · Answer

Cannot use any marketplace apps here... so will try to figure this out using native.

Karolina Wons_SaaSJet · Answer

Hello @Ignas Selvestravičius

Time in Status for Jira Cloud becomes helpful in your case. It generates an Average time report (and 6 more status time reports) on a Dashboard.

All you need is to add a Gadget to a Dashboard. Configure a Gadget according to your needs (choose an Average time report type, project, and "Created yesterday" as Date ranges.

You'll get data based on a previous date on your Gadget.

Also, you can create a Status Group to get the information you need.

It's developed by my team and is free for using up to 10 users. Please, let me know if you have any questions.

Hope it helps.

Emre Toptancı _OBSS_ · Answer

Hello @Ignas Selvestravičius , On your dashboard or other reports, if you are selecting your issues based on a JQL query, you can use the "startOfDay()" and "endOfDay()" JQL functions for this purpose. As the name suggests, these functions point to the beginning and end of each calendar day. When used without a parameter, they point to the beginning and end of today. But you can also use them with positive or negative integer parameters to refer to previous or future days. For example: project = ABC and created > startOfDay() and created < endOfDay() This will get you the issues that are created today and only today. Another example with parameters: project = ABC and created > startOfDay(-1) and created < endOfDay(-1) This will get you the issues that are created yesterday and only yesterday. It will exclude earlier days and it will also exclude today. I can also suggest an alternative solution with our Time in Status app. It is available for Jira Server, Cloud, and Data Center. Time in Status has Duration Between Statuses report which works like an SLA timer that shows the duration for each issue between status A and status B. You can also get the averages of these durations grouped by issue fields you select. Grouping by year, month, week, day, hour is also possible so you can see and compare several days at once. (The screenshot below shows a Status Duration report grouped by month but it is pretty much the same for a Duration Between Statuses report grouped by days.) https://marketplace.atlassian.com/apps/1211756/ EmreT