SLA remaining interval

Questions & Answers
1

Hi,

I want to build a report based on remaining time for SLA field “Time to resolution” before it breeches for all open issues. The results has to be shown in interval (like age interval) based on these querys:

  • “Time to resolution” < remaining (“4h”)
  • “Time to resolution” < remaining (“7,5h”)
  • “Time to resolution” < remaining (“22,5h”)
  • “Time to resolution” < remaining (“37,5h”)

I am thinking of displaying this as a Bar diagram that shows the different intervals in row section and issue count on how many issues remaining pr. interval in column section.

Is this possble to achieve?

Peder

2

Hi Peder,

There is the Due date property available for all issues with an SLA if the issue has ongoing cycle of this SLA.

Your use case can be implemented by creating new measues for each of your intervals with the formula like this:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Time to resolution Issues]>0
  AND
  DateDiffHours(Now(),
    [Measures].[Issue Time to resolution Due date])<4
  )
))

Kindly,
Janis, eazyBI support

3

Hi,
,
Thank you, it worked:)

So for the next measure interval, e.g “Time to resolution” < remaining (7,5h), it should look something like this?:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Time to resolution Issues]>0
AND
DateDiffHours(
Now(), [Measures].[Issue Time to resolution Due date]) < 7.5
)
))

Best regards,

Peder

4

Yes, Peder, that could be a solution.

Alternatively, if you wish to exclude the issues from the lower interval, the formula is like this:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Time to resolution Issues]>0
  AND
  DateDiffHours(Now(),
    [Measures].[Issue Time to resolution Due date])>=4
 AND 
DateDiffHours(Now(),
    [Measures].[Issue Time to resolution Due date])<7.5
  )
))

Kindly,
Janis, eazyBI support