Community
Q&A
Jira Service Management
Questions
How can I export negative time values to csv correctly?

How can I export negative time values to csv correctly?

Hi,

When a ticket breaches an SLA, the time value goes into the negative. For example, if i had an SLA of 2 hours and I breach it by 1 minute, the time value is -1 minute. When I export this data into a csv format, these values show up as "#VALUE" instead of the the real value.

Is there anyway around this?

My goal is to load this data into Power BI to find the average elapsed time for a ticket to be assigned.

Thanks!

Dave

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

Hi @David Anthony

You can export data with app SLA Time and Report, which counts SLA time not only for the Service Desk tickets but also for all issues from Jira Cloud (Jira Software, Jira Core).

sla for community.jpg
In case if you need the average time assignee had spent on each ticket, try the report Average Time from this app. To get average elapsed time, you need to create a status group that will be including statuses from support (for example, "Waiting for support", "Testing", etc when your SLA is counting).

Hope it helps

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira Service Management

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How can I export negative time values to csv correctly?

1 answer

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events