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

**URL:** <https://community.eazybi.com/t/count-of-cases-that-will-breach-slas-in-less-than-12-hours/5610>\
**Category:** Questions & Answers\
**Tags:** jira-service-desk, jira, calculatedmembers, sla\
**Created:** [November 11, 2020, 10:02pm UTC](https://community.eazybi.com/t/count-of-cases-that-will-breach-slas-in-less-than-12-hours/5610 "2020-11-11T22:02:29Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![lauma.cirule](https://community.eazybi.com/user_avatar/community.eazybi.com/lauma.cirule/32/8830_2.png) [@lauma.cirule](https://community.eazybi.com/u/lauma.cirule)\
**Post date:** [November 25, 2020, 1:13pm UTC](https://community.eazybi.com/t/count-of-cases-that-will-breach-slas-in-less-than-12-hours/5610/2 "2020-11-25T13:13:02Z")

</div>

Hi @raineroller!

You are right; making such a report with eazyBI is not as simple - it requires an [Age dimension](https://docs.eazybi.com/eazybi/analyze-and-visualize/interval-dimensions) 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).

 ![Issues_-_eazyBI](https://community.eazybi.com/uploads/default/original/2X/a/ad5ec3b8156bb98ae12fe0c3a9f421849a200abe.png)

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)](https://community.eazybi.com/t/measure-formatting-markdown-and-custom/5157)

```
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](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/count-of-cases-that-will-breach-slas-in-less-than-12-hours/5610)._