Mehmet A _Bloompeak_ Atlassian Partner

Hi @[deleted] , Welcome to the community! Unfortunately it is not possible out-of-the-box in Jira. JQL does not have capability to compute time spent between statuses. However, the data you need is implicitly available in issue history. You can get issue history via Jira rest api and then you need parse the json…

Hi @Tyas Iglecias , "Get issue rest api" provides historical data once you provide expand=changelog query parameter. It returns json response as below. Then you need to parse the response, extract the data and make your calculation. Or, you can try Marketplace apps which do the parsing and calculation for you. You can try…

Welcome to the community @Sjoerd! If you update the assignee field of the ticket to the actual user working on it, then Status Time app might help. Apart from the default "status time" report, the app provides assignee time report similar to the below format. Issue | Person 1 Assignee date | Person 2 Assignee date |…

Hi @Andrei Iorga , I am not sure, but can it be the case that it requires the requestor of the REST call to have admin rights? That is, if you are not admin, jira does not allow to view groups of another user.

Hi @codingouch , Unfortunately it is not possible out-of-the-box with JQL. JQL does not have capability to compute time spent between statuses. However, the data you need is implicitly available in issue history. You can get issue history via Jira rest api and then you need parse the json response(similar to the below),…

Hi @Raj Learn , Here is the Rest API documentation for issue creation. https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-post

Hi @Frank Nägele , "Get issue rest api" provides historical data once you provide expand=changelog query parameter. https://docs.atlassian.com/software/jira/docs/api/REST/8.13.1/#api/2/issue-getIssue

Hi @Caroline , Others should have access to the issues in order to get statistics. That might be the problem. On the other hand for a more powerful status time reporting you can try Status Time app. It provides various status time reports. Once you enter your working calendar into the app, it takes your working schedule…

Hi @Swaroop , You can try Status Time app developed by our team at Bloompeak. It provides reports on how much time spent on each status as well as status entry dates and status count. 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…

Hi @fobrutsky , You can try Status Time app developed by our team at Bloompeak. It provides reports on how much time spent on each status as well as status entry dates and status count. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an…

Hi @Brad Chattillion , The info is implicitly available inside Jira and you can get it for each issue over Jira rest api as below. Then you need to parse the response, extract the data and make your calculation. Or, you can try Marketplace apps which do the parsing and calculation for you. You can try Status Time app…

Hi @fobrutsky , The info is implicitly available inside Jira and you can get it for each issue over Jira rest api as below. Then you need to parse the response, extract the data and make your calculation. Or, you can try Marketplace apps which do the parsing and calculation for you. You can try Status Time app developed by…

Hi @[deleted] , You can try Status Time app developed by our team at Bloompeak. It provides reports on how much time spent in each status as well as status entry dates and status transition count. It also has export functionality. Once you enter your working calendar into the app, it takes your working schedule into…

Hi @Roger Hancock , If you want status transition dates of a bunch of issues as an excel-like report, you can try Status Time app developed by our team. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Once you enter your working calendar into the app, it…

Hi @Karanpreet Kaur , If you are specifying blocked issue with a specific status, you can try Status Time app developed by our team. t provides reports on how much time spent in each status as well as status entry dates and status transition count. Once you enter your working calendar into the app, it takes your working…

Hi @Deepak Suresh , You can try Status Time app developed by our team at Bloompeak. It provides various reports. One of them is status entry dates. You can list status entry dates as well as resolution dates of issues with a jql like 'status changed AFTER endOfMonth(-1) and status = done' and export the report. Then you…

Hi @Виктория , As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Hope it helps.

Hi @Roland Weilbacher , As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Here is the online demo link of unlimited version, you can see it in action and try. Hope it helps.

Hi @Vera Valshonok , If you use statuses to differentiate non-jira user assignments, you can use status transition dates. Our team at Bloompeak developed Status Time app which provides reports on how much time spent in each status as well as status entry dates and status transition count. Once you enter your working…

Hi @Fernanda Grandizoli , As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Hope it helps.

Hi @Johnson Anthony , As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Hope it helps.

Hi Ibrahim, As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Here is the online demo link of unlimited version, you can see it in action and try. Hope it helps.

Hi @Sharona Keren , One of the indicators of the progress is the time spent on each status and a groups of statuses(lead/cycle time). We developed Status Time app for that specific reason. It provides reports on how much time spent in each status as well as status entry dates and status transition count. It also has export…

Hi Dionei, In my experience, in our team SREs mostly work on bugs and tasks. Some of the tasks are solely infrastructure related routines e.g. applying a security patch or renewing ssl certificates. Some tasks are part of a user story e.g. provisioning elastic search that is required for brand new search story being…

Hi @Giuseppe Costa , welcome to the community! If you are using a specific status to indicate that issue is resolved, then you can use status transition date. There are marketplace apps which provides reports on status time and status transition date. One of them is Status Time developed by our team at Bloompeak. It…

Hi @bala, Welcome to the community! As far as I know, "resolution time report" is not built-in inside Jira. There is "time to done" report which is available in Jira Service Desk. As an alternative you can use Status Time app developed by our team at Bloompeak. It provides reports based on time spent in statuses. The app…

Hi @s.kern , There are marketplace apps which provide reports on status changes. One of them is Status Time app developed by our team at Bloompeak. It provides reports on how much time spent on each status as well as status entry dates and status transition count. Once you enter your working calendar into the app, it takes…

Hi @Gerda Tilk , As an alternative, you can try Status Time. If you are looking for a free solution there is also limited but free version of above, Status Time Free.

If you are looking for a free solution, you can try Status Time Free app.

Hi @Tim Bäßler , The info is implicitly available inside Jira and you can get it for each issue over Jira rest api as below. Then you need to parse the response, extract the data and make your calculation. Or, you can try Marketplace apps which do the parsing and calculation for you. You can try Status Time app developed…