Count of cases that will breach SLAs in less than 12 hours

I want to create a table in eazybi similar to the one below, so that it’s easier for my team to prioritize cases that are about to breach their SLAs.

For the life of me, I cannot figure out how to create a calculated measure to that extent. The table itself is set up and I know I’d need different measures for each time frame but otherwise I haven’t gotten very far with creating the calculated measures themselves. Everything I try brings up no results.

Hi @raineroller!

You are right; making such a report with eazyBI is not as simple - it requires an Age dimension for dates that are in the future.

I can offer the following solution to your question, though - create a table with Issues on rows and filter those that have Running desired SLA (1).

I am ordering the issues by their SLA due date (2).

For visualisation (3), I have created two calculated measures:

a) Time to First response remaining, which is not selected but calculates the hours remaining until the due date.

CASE WHEN NOT IsEmpty([Measures].[Issue Time to first response Due date])
THEN Int(Round(0 - DateDiffHours(
  [Measures].[Issue Time to first response Due date],
  Now()
)))
END

b) Time to first response remaining h which uses the first measure and formatting described here Measure formatting (markdown and custom)

CASE 
WHEN 
[Measures].[Time to First response remaining] < 12 
THEN 
    "<p style='text-align:right;'>" ||
    "<i class='far fa-alarm-exclamation' style='color:red'></i>" || " " ||
    Str([Measures].[Time to First response remaining]) || "h" ||
    "</p>"
WHEN 
[Measures].[Time to First response remaining] > 12 AND 
[Measures].[Time to First response remaining] < 24 
THEN
    "<p style='text-align:right;'>" || 
    "<i class='far fa-alarm-clock' style='color:orange'></i>" || " " ||
    Str([Measures].[Time to First response remaining]) || "h" ||
    "</p>"
WHEN [Measures].[Time to First response remaining] > 24
THEN
    "<p style='text-align:right;'>" || 
    "<i class='far fa-alarm-snooze' style='color:green'></i>" || " " ||
    Str([Measures].[Time to First response remaining]) || "h" ||
    "</p>"
END

Let me know if that helped or if you have further questions regarding this!
Lauma / support@eazybi.com