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

Hi I need to get the data of how much effort was spent in the below 2 statuses vs the estimated time

unknown

Hi All,

Can i get a report considering estimated time in JIRA when generating reports on how long a case took to develop.
I need to only consider following statuses that is correlated with estimated time : Building and configuring & System testing.
Also to only show data for cases that are already closed which means that they are either in production or withdrawn requests.

Is it feasible to get such data from jira or is there any add-on which can provide such data.

Accepted answers

All comments

Petter Gonçalves

Hello Shrikant,

I understand that you would like to have the amount of logged time that was registered when the issues were in two specific statuses (Building and configuring & System testing). Is it correct?

This functionality can be achieved by using the Pivot by Status report provided by the Time Reports app:

Screen Shot 2019-07-30 at 16.06.38.png

Let me know if this would be an option for you.

unknown

@Petter Gonçalves

Thanks for the reply, but i am looking for in relation to the Estimated time.

I fill be filling the estimated time for different issues now what is am looking for is to get a report which will show the trend of my issues under the 2 statuses VS the Estimated time.

So that i will understand how much is the deviation between the actual time and estimated time and then can work accordingly.

Petter Gonçalves

Thank you for your answer, @[deleted]

Correct me if I'm wrong, but I believe you are trying to get a report with the time spent in the two mentioned statuses together with the Estimated time of the issue (Including all the statuses).

Using the plugin suggested, there's a parameter called Additional fields that you can use to add the time estimation in the same report:

Screen Shot 2019-07-31 at 11.33.16.png

Additionally, you can export the report to CSV and sum/decrease the time logged from the total time estimated, getting how much of the total time estimation was applied in these two statuses.

Let me know if this information helps.

unknown

@Petter Gonçalves

Thanks a lot Peter but i am unable to upload this file as while uploading this into JIRA it keeps on rotating and is not getting installed, pfa scrren shot for the same. Let me know how to install this add-on.

Emre Toptancı [OBSS]

Hello @[deleted],

Our team at OBSS created Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can report how much time each issue spent on each status. You can choose to include, exclude or combine certain statuses and you can add any issue field (including estimation fields) to this report so you can see estimations and actual durations side-by-side.

As well as statuses, you can report how much time each issue spent on each assignee or even each user group. The app also has two level reports that show status durations broken down by assignees or vice versa.

You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours. This is important because a report based ona 24/7 calendar does not make sense most of the time. Any issue that was opened on a Friday close to the end of business day and that was resolved early morning of next Monday will seem to be resolved in two and a half days on a 24/7 calendar which in fact is resolved in a few business hours. Custom calendars let you see that.

All data can be exported as XLS, XLSX, CSV.

Timepiece - Time in Status for Jira

Emre Toptancı

Mehmet A _Bloompeak_

You can use Status Time app. It generates status time report based on your working calendar.

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