How can I export negative time values to csv correctly?

[David Anthony]

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

[Zoryana Bohutska _SaaSJet_]

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).

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