# How to create a dashboard to show incidents about to miss SLA?

**URL:** <https://community.eazybi.com/t/how-to-create-a-dashboard-to-show-incidents-about-to-miss-sla/15799>\
**Category:** Questions & Answers\
**Tags:** jira-reports, eazybi, sla\
**Created:** [February 26, 2024, 9:12pm UTC](https://community.eazybi.com/t/how-to-create-a-dashboard-to-show-incidents-about-to-miss-sla/15799 "2024-02-26T21:12:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![walterdp](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/f04885/32.png) [@walterdp](https://community.eazybi.com/u/walterdp)\
**Post date:** [February 26, 2024, 9:12pm UTC](https://community.eazybi.com/t/how-to-create-a-dashboard-to-show-incidents-about-to-miss-sla/15799/1 "2024-02-26T21:12:35Z")

</div>

Hi all:

Is there a way to create a report in EazyBI or in JSM to help Incident Management team to identify group of incidents ordered by SLA due date (for instance: 10 tickets will miss SLA in the this week, 23 will miss it in the next week, etc.)?

Thanks!

W.

---

<div class="post-metadata">

**Author:** ![oskars.laganovskis](https://community.eazybi.com/user_avatar/community.eazybi.com/oskars.laganovskis/32/5902_2.png) [@oskars.laganovskis](https://community.eazybi.com/u/oskars.laganovskis)\
**Post date:** [February 29, 2024, 9:20am UTC](https://community.eazybi.com/t/how-to-create-a-dashboard-to-show-incidents-about-to-miss-sla/15799/2 "2024-02-29T09:20:03Z")

</div>

Hi @walterdp ,

You might define a new JS customfield retrieving the Due timestamp from the issue data.

You might read about creating a new calculated field here - [New calculated fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/new-calculated-fields)

The JS code might be something like the following,

```auto
if (issue.fields.customfield_NNNNN && issue.fields.customfield_NNNNN.ongoingCycle){
var duestamp = issue.fields.customfield_NNNNN.ongoingCycle.breachedDate;
var duedate = new Date(duestamp);
return duedate.toISOString();}

```

where NNNNN stands for the customfield ID for the respective SLA.

You might then import this field as a datetime measure. That would create a new measure - “Issues with \<custom date field\>”.

Then, you might find the issues about having the SLA breach on a specific date with a calculated measure having the following tuple.

```auto
([Measures].[Issues with <custom date field>],
 [<SLA name> State].[Running])

```

Regards,

Oskars / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![walterdp](https://community.eazybi.com/letter_avatar_proxy/v4/letter/w/f04885/32.png) [@walterdp](https://community.eazybi.com/u/walterdp)\
**Post date:** [February 29, 2024, 7:13pm UTC](https://community.eazybi.com/t/how-to-create-a-dashboard-to-show-incidents-about-to-miss-sla/15799/3 "2024-02-29T19:13:39Z")

</div>

Hi @oskars.laganovskis

Thanks for answering. Finally I found an answer in another forum. I can’t find the link now, but in the post they shared this demo [SLA with ongoing cycles - Jira Service Management Demo - eazyBI](https://eazybi.com/accounts/1001/dashboards/42282-sla-with-ongoing-cycles).

I adapted one of the reports and that’s what I needed!

Thanks anyway!

W.