Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to export values of Time to First Response and Time to Resolution

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

2 comments

Hi Shpendi,

Can you explain the exact steps you took to export these values to Excel? I'm asking this because I've just tried to reproduce your issue but in my case the Excel report looks ok.

 

Excel.png

If you don't want to bother with exporting, I can recommend using Time to SLA for Cloud. It comes with built-in reports to analyze SLA elapsed duration and working duration for deeper analysis.

SLA ek Açıklama 2020-06-23 182151.png

SLA ek report.png

I'm one of the folks in Snapbytes so if you have more questions just ask away.

Best,

Gökçe

Like # people like this

Hi @Gökçe Gürsel _Appfire_ 

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.Working duration - TTS CLoud.png

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

Like Shpendi Rakipi likes this

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

URL.JPG

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?

Comment

Log in or Sign up to
This widget could not be displayed.
TAGS
Community showcase
Published in Jira Service Management

Announcing: Incident Responders and Linked Alerts in Jira Service Management

THESE FEATURES ARE NOW AVAILABLE FOR ALL CUSTOMERS --- Hello Atlassian Community! Today, we’re excited to announce the rollout of two new incident management features in Jira Service Managem...

1,056 views 8 12
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you