Time to spent is displayed empty

[Sally Abd Elrahman]

Dears, 

Kindly i need your help in the below

I'm trying to create a query to show service ticket with time spent to fix the ticket, but I'm facing a problem that the time spent field is always displayed as Empty value. 

Kindly check the below screen shot for more elaboration.

[Mehmet A _Bloompeak_]

Hi @Sally Abd Elrahman ,

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.
 

[Emre Toptancı _OBSS_]

Hello @Sally Abd Elrahman ,

Jira does not calculate status durations by itself and the Time Spent column in issue navigator shows the sum of manual worklog entries on the issue.

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ı

[Zoryana Bohutska _SaaSJet_]

HI @Sally Abd Elrahman 

If you need to view data about the time spend in each status app Time in Status for Cloud Jira can help you. This add-on can generate 7 reports: time in status, average time, assignee time, status entrance date, time in status per date, status and transition counts.

Also, users can monitor reports as charts and view data thought issue view panel.

I hope it will help you with your request.

Best Regards,
Zoryana,
SaaSJet Team

[Nic Brough -Adaptavist-]

Do your issues have work log entries?

[Sally Abd Elrahman]

Shouldn't the time be calculated automatically from "Issue create time" till "Issue close", taking into consideration the SLA time also?

If not, then how to add the work log? i check the fields available in ticket details but i couldn't find that 

Actually i can see the elapsed time displayed in "Time to spent" report. but i can't extract it through the issue navigator. 

[Nic Brough -Adaptavist-]

No, time spent is the accumulation of all the work logs.  Your people should use "log work" from the tools menu to record them if you want to do actual time spent recording.

The elapsed time (which is very different from time actually spent on an issue) is reported by the SLA, not time spent.