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