You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Dear all,
I would like to export values of Time to First Response and Time to Resolution as numbers from the Jira Service Desk Cloud Platform.
I've already added the colums in the filtering section but once I export, I get errors/formula errors in Excel.
Does someone know how to extrat them as values, not as formula, or is it something I should work on in Excel?
Regards,
Shpendi
Thank you for your speedy reply!
Actually, Time to First Response and Time to Resolution does export but when I try to click on the cell, I get an formula error (because excel takes the minus sign as a formula request).
I have to select all the values and add an ' before the - to deactivate the formula. Do you know any way how to export them just as values without the need of extensions and without the need of extra work on Excel?
Hi Shpendi,
This is a hard one. I've tried several things (text to number, formatting the cells, etc) but they didn't work. Maybe you can write a custom macro to parse the cell but it can be quite the hassle. You can also make a feature request to Atlassian to export these numbers in a format; a feature that Time to SLA already has.
Let me know if you need further information.
Regards,
Gökçe
Hi @Gökçe Gürsel {Appfire} ,
Thank you! I've found a winning option. After generating the report, select the columns (don't select a single cell). Go to Find and Replace and put: find - and replace with '-. In this way, Excel will not recognize it as a formula and at the same time the ' will be hidden.
I wish there was a shorter way, without the need of using extentions.
Many thanks,
Shpendi
This is a good solution, albeit it contains several extra steps. I'm glad that you found a solution.
Take care.
Gökçe
Hi @Gökçe Gürsel {Appfire}
Hope all is well. I have a quick question.
This is how my time to first response or time to resolution appears when I export it to Excel
Any idea on how I can convert this into minutes?
Thanks
Hi @cosorio ,
I think you need to change this format to hh:mm by replacing d and h with : and then using the TIMEVALUE function. You can refer to these:
https://exceljet.net/formula/parse-time-string-to-time
https://fiveminutelessons.com/learn-microsoft-excel/use-timevalue-function-convert-text-time-excel
Cheers,
Gökçe
I want to record the duration of each state in each case. Where can I apply it in JSM?