How to correctly pull data from Jira SD into excell

Question

Hello everyone...whenever I try to download all fields in filter via CSV "time to resolve" format is in so odd time format and "time waiting on customer has extra characters in the value that causes errors (screenshot attached). Also is there a field that will allow me to me see the time it took to resolve on a SLA clock and not time remaining? Also when I try to export into XLM I get major error: " This XML file does not appear to have any style information associated with it.The document tree is shown below"

Thank you in advance for your help

Gökçe Gürsel {Appfire} · Answer

Hi Rob,

Happy to have you onboard :)

We've answered your tickets at the same day but now I realize there is a mixup. I'm replying to you through email right now.

Edit: Just sent you an email. Thank you for notifying me.

Best,

Gökçe

Rob_fdqvsu · Answer

Hello Gokce...I have your app on review. I put in a service ticket last weds and waiting to hear back. SnapDesk-575

Gökçe Gürsel {Appfire} · Answer

Hi Rob,

For one of a kind SLA reports, I suggest Time to SLA.

It has a detailed report and summary report features that give their users both a summary report and a report that has pieces of detailed information such as remaining time, working duration on the SLAs. You can then export these reports to Excel in the format you want (human readable, only in minutes, only in seconds) for further analysis.

Let me know if you have any questions.

Best,

Gökçe