How do I pull the breached SLA incidents over the past 12 months? (Visual Design)

[Calvin]

Hi all, trying to create a dashboard of a custom field of type "asset multi select". I was able to pull this column in and used explode to get every version of this asset field.

In the filter I pull out [SLA Table] "Breached = True" & [SLA Table] "SLA Name" = "xxxx". But it seems like the breached value is only calculated when the ticket is closed. I'm trying to get a count of how many tickets were breached including currently breached in the last 12 months.

If it helps I can proxy "created in last 12 months" to make it easier but I still miss out on all tickets that are breached but not yet closed.

I can't seem to find that value or a goal value in the table to work out what is breached but still open.

Cheers!

[Alina Kurinna _SaaSJet_]

Hi @Calvin 

If you’re looking to monitor SLA breaches (exceeded), including for open issues, over a 12-month period, I’d suggest trying our app – SLA Time and Report, which was built exactly for these types of advanced reporting needs.

Why native Jira reports miss open SLA breaches.

You're right – in native Jira, SLA "breached" status is typically updated only when an issue reaches a stop condition (e.g. Resolved or Done). That’s why tickets still in progress often get skipped in breach reports.

With SLA Time and Report, you can:

• Track SLA breaches for both closed and ongoing issues

• Filter by SLA Name, status, and date (e.g. “last 12 months”)

• Analyze custom fields in the report

• Use Met vs Exceeded charts for trend visualization

• Export clean SLA reports with only the fields and goals you need

• Add SLA gadgets to your Jira dashboards

Met vs Exceeded chart (breaches):

Met vs Exceeded per Criteria (you can use Jira fields or custor fields):

If you're open to trying Marketplace apps, feel free to test it out. Let me know if you have any questions – happy to help!

Regards!

[Danut M _StonikByte_]

Hi @Calvin,

I'm not familiar with AA, but in Jira you can get the SLA breaches for issues created past 12 months by using a filter like this: 

"Time to resolution" = breached() and created > startOfMonth(-12)

Perhaps you can use it in AA.

Another possibility would be to try an app from Atlassian Marketplace. In case you want to try an app, our Great Gadgets app offers many useful gadgets for tracking SLA breaches in real-time.

For example, using the Pivot Table & Pivot Chart gadget with a filter like the one above, you can display SLA breaches by team members on a monthly basis.

The Control Chart gadget can identify the SLA breaches for issues that are closed.

While the WIP Aging Chart gadget can identify the breaches for the issues that are not yet closed, but breached the SLA.

See more examples in this article:

https://community.atlassian.com/forums/App-Central-articles/SLA-Breaches-in-Jira-What-they-are-why-they-happen-and-how-to/ba-p/3093193

Danut.

[Dan -minware-]

Note: I am a 3rd party marketplace vendor

I'm not sure if AA will work - we developed minQL to handle complicated situations like this. Our platform is time-native and we shouldn't need a proxy.

There is a bug SLA report you can find in our live demo if you want to check out an example (or screenshots below) and if you want to spin up a free trial my team is happy to build that out for you.

Good luck finding a solution and please reach out if we can help.

Dan