I want to pull the duration(time) taken between different status of the tickets (such as assigned to

[Sreenadh]

Hi,

I want to pull the duration(time) taken between the different status of the tickets (such as assigned to resolved, New to closed etc..

We need to present this data in dashboard/report.

We wanted to capture the total time taken to for an issue between Creation to Closed

Initial Analysis to Assigned to any team. -------------- How much time

Assigned to the team to in progress.----------------- How much time

In Progress to Resolved -----------------How much time

Resolved to Closed------------------ How much time.

Kindly help me out how to pull the report and share it with the Customers.

Thanks,

[Tom Zhu · Accepted solution]

Hi @Sreenadh 

You can try this app  Time in Status

Time in Status allows you to easily create reports on issues that show how much time each issue spent on each status, assignee, or group.

Regards,

Tom Zhu

[Sreenadh]

Hi @Tom Zhu 

Thanks for response.

Sure, let me try this Addon and i will keep update if it will satisfy my requirement.

Thanks,

[Tom Zhu]

My pleasue , keep contact , have a nice Day 😄

[Sreenadh]

Hi @Tom Zhu 

I have used this Addon and i want to know whether this could be accessed by the End users.which means does have only Customer portal access.

[Tom Zhu]

Hi @Sreenadh 

If you want to make the report access to End user. I suggest you to do some development job

1. generate report or dashboard by 【time in status】or【eazyBI】as PDF
2. send it to customer’s mailbox by rule ， such as once a week or when customer updated issue or ticket was closed.

Tom Zhu

[Mehmet A _Bloompeak_]

Hi @Sreenadh

As an alternative, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app.

• This app 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 the working 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.

If you are looking for a free solution, you can try the limited version Status Time Free.

Hope it helps.

[Rahul_RVS]

Hi @Sreenadh 

As an alternative, you can also try out our plugin,

Time in Status Reports 

The add-on provides the time in each status for the entire lifecycle of the issue, based on the date range, assignees and multiple other filters.

The app is free upto 10 users

Disclaimer : I work for RVS, the vendor for this app