Calculate Time of Resolution in WorkDay Hours - No capturing decimals

Question

I'm trying to calculate the time to resolution of a ticket in a separate field in order to be able to display it on a dashboard. I'm not interested in a third party plug-in so I'm trying to figure it out using a calculated field.

To get the duration in working hours I'm using:

{{#=}}{issue.created.diff(issue.resolved).businessDays}}*11{{/}}

My custom field is a number field. It works, but it's not producing any decimals. Perhaps it won't because I'm using business days?

I tried rounding:

{{#=}}ROUND({issue.created.diff(issue.resolved).businessDays}}*11,2){{/}}

but that didn't work.

I tried creating another custom field and used:

but that didn't work either.

Any suggestions?

Steve Fitzgerald_59zj2k · Answer

Thanks. I was multiplying it by 11 because our workday is 11 hours long and I was trying to figure out how many working hours between creation date and resolution. Does the smart value you included look at working days/business days vs absolute dates/minutes?

Murat Seven · Answer

Hi @Steve Fitzgerald and thanks for your question.

It seems like you want to display the time between the issue's resolution and creation in a custom field of type 'number.' I'm not entirely sure why you're multiplying it by 11 in the smart value, but the reason it might not be working is that instead of using the term 'businessdays,' you can use 'Minutes.'

Your smart value could look like this:

I hope this information helps.

Regards,

Murat Seven