Hello All,
Time to resolution elapsed report we can generate in eazybi.
We would like to create a report
Actual Time to Resolution Time , Elapsed time and Remaining time (Actual Time resolution - Elapsed time)
Could you please help us to create a report.
Regards;
Thangavel
1 Like
Hi,
The first step towards the solution is to import the SLA goal time. This community post shows how to import the goal time using a Javascript-calculated custom field: How can I calculate the contractual penalties for issues that are in SLA breached? - #3 by lauma.cirule.
Once you do that, you can create a custom calculation like this to show the remaining time till the SLA breach for issues without a completed SLA cycle:
CASE WHEN
[Measures].[Time to resolution Issues]>0
AND
IsEmpty([Measures].[Time to resolution Elapsed hours])
THEN
[Measures].[Time to resolution Goal created]
-
DateDiffHours([Measures].[Issue created date],Now()) --time since issue creation
END
Kindly,
Janis, eazyBI support