Time in status - Show in tabular format

[Shantanu Sen]

Hello, 

I do not have admin access to the JIRA and I am using as part of the corporate access. Thus I will not be able to install any plugin or I do not have the rights to create custom fields. Hence I need some workaround to get the data.

Problem Statement: I have a KANBAN board and there are issues reported. There are two teams between which the issue is switched. I want to extract two types of data 

• Lifetime of a issue - Total time from issue open to issue close
• Total time the issue was with Team A
• Total time the issue was with Team B

Ideally i have the only way to get this data through JQL and process it in excel, but what should be the query for both the data.

Thanks

[Ste Wright]

Hi @Shantanu Sen

You can view the lifetime of an issue based on the difference between created date to resolved date (as long as resolution is being set when an issue is closed).

Time spent with each team will be difficult without an add-on. You could request the team populate the "Time Spent" on each issue via the work logs, but on export this will show just the total amount spent - rather than time per user.

You could look to pull this data out via the REST API based on each assignee (attributed to a team) - or you would need to look at a Timesheet or Time in Status-style app for your instance.

Not all apps cost if this is a concern - for example JAssistant is free and mentions worklogs and timesheets, perhaps one of their functions would be of help?

Ste