Time to spent is displayed empty

Question

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_ · Answer

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] · Answer

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_ · Answer

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