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