Export the SLA Custom Field to Excel

We have setup SLAs in Service Desk which show up nicely in the ticket:  

Screen Shot 2015-02-23 at 3.02.20 PM (2).png

and shows up in the issue navigator:

Screen Shot 2015-02-23 at 3.02.12 PM (2).png

However, for reporting we need to export this data to Excel to show how long we have gone past SLA or something, but the data does not seem to be there.  Excel shows the dreaded #VALUE! in the exported field.  

Is there anyway to export this data?  

1 answer

1 accepted

1 vote
Boris Berenberg Community Champion Feb 23, 2015

The actual field data is a set of JSON which contains relevant transition information. As such, there is no good way to export it to Excel at this time. The good news is that this is a known issue: https://jira.atlassian.com/browse/JSD-149 and is currently being worked on.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Mar 09, 2018 in Jira Service Desk

E.L. Fridge's take on education, Jira Service Desk, and creative Jira use cases

...word of mouth, so by 2016, we were working with several other entities on campus to implement Jira Service Desk . The Atlassian motto of “for every team” has really come true for us in this case. We...

966 views 2 14
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you