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; } } }

Is it possible to retrieve via REST API a report (like average development time) by project ?

Pablo Bernardo_k2p32d

I want to retrieve a report like the Control Chart via REST API (Jira Cloud) to mainly see the average time spent in several statuses on a specific period.

It should be based on the project and not on boards (we have several boards per project).

The idea is to automatically put this data on a Google Sheet to manage it in different ways.

Is this possible?

Any help here?

Accepted answers

Emre Toptancı [OBSS]

Hello @Pablo Bernardo

Jira does not give this information out-of-the-box but I think I got the perfect thing for you. Our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud, and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time, or Lead Time. You can calculate averages and sums of those durations grouped by the issue fields you select.

What's better, you can get all this report data on-screen or using the new REST endpoints introduced by Time in Status.

Even better, we have some sample Google Sheets and Excel templates that already contain the scripts needed to pull data from REST endpoints into spreadsheets. You just set the parameters and get your data into the spreadsheet with a single click:

https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+Sample+Spreadsheet+Integration+Files

tisCloud_StatusDuration_LeadTime_with Estimates.png

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Using Time in Status 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 issue type.)
Export your data as XLS, XLSX, or CSV.
Access data via REST API. (for integrations)
Visualize data with various chart types.
See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/1211756

EmreT

All comments

Emre Toptancı [OBSS]

Hello @Pablo Bernardo

What's better, you can get all this report data on-screen or using the new REST endpoints introduced by Time in Status.

https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+Sample+Spreadsheet+Integration+Files

tisCloud_StatusDuration_LeadTime_with Estimates.png

Using Time in Status 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 issue type.)
Export your data as XLS, XLSX, or CSV.
Access data via REST API. (for integrations)
Visualize data with various chart types.
See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/1211756

EmreT

Bill Sheboy

Hi @Pablo Bernardo

You note having multiple boards per project, and that would seem to indicate having multiple teams per project. Is that correct?

If so, measuring average time in status across different teams' boards may not be a helpful measure. What problem are you trying to solve by measuring that?
If instead this is one team, and they have multiple boards to manage work, what problem are they solving by doing that?

And...the REST API can already access history data for issues. You note wanting to pull this information into an external spreadsheet for processing, meaning you need the ability to parse the JSON by issue. Have you considered performing the time calculations directly in that spreadsheet with the history data?

Thanks, and best regards,
Bill

Pablo Bernardo_k2p32d

Hi @Bill Sheboy !

I see your point but for us it is currently important to have that metric for the global measure we are trying to improve.

About the API, yes, I have considered doing all the calculations, but in case I see this as the only option, I'd probably for other metrics or ways to address those issues.

Pablo Bernardo_k2p32d

Thanks, @Emre Toptancı _OBSS_ , I will check this one.

Nicola D.

Hi, you may try this script https://github.com/WuerthPhoenix/Atlassian-Extension-Scripts/tree/main/jira-worklog-report-csv that export all work log into csv line by line .

Something similar can be done for on-status time calculation

cheers

Julia Shcherbyna _SaaSJet_

Hi @Pablo Bernardo

Another solution you can check is Time in Status for Jira Cloud. It's a top-rated time monitoring app developed by my team.

Using it, you can get an Average time report spent in several statuses on a specific period.

time reporting period.png

You can export the data for further detailed analysis.

Hope it helps.

Regard

Mehmet A _Bloompeak_

Hi @Pablo Bernardo ,

For this exact need we developed Status Time app. It provides reports on how much time passed in each status, 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 opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try without installing the app.

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

rest-api

api

atl-gruland

report