Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

How to count Jira issues based on severity when the response time is greater than SLA using eazyBI

How to count Jira issues based on a custom field (Severity options High, Medium, Low) when the response time is greater 2h (SLA)?

3 answers

Suggest an answer

Log in or Sign up to answer

Hi Vinay - 

As per my understanding "Severity" does not come as a default field unless you have added a custom field....In that case you can use JQL to filter out result using it as a parameter. Else you can use "Two Dimensional Filter Statistics" widget on dashboard to extract the count using "Priority" or "Severity" (custom field).

Hope you find it useful.

Anne Saunders
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Apr 20, 2023

This is exactly what I was going to suggest.

1 vote
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 19, 2023

@Vinay Sharma -

You can construct JQL search filter to achieve your ask -  Here is how to construct JQL for issues dealing with SLA + you can then further tune you JQL to include the Severity field criteria.

https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/

In regards to generate report in EasyBI - Take a look at the following references  (NOTE: the following links are focusing on SLA reporting which doesn't include the Severity criteria refrerence, but you should be able to include it as a reporting dimension -

https://eazybi.com/blog/jira-service-management-slas-reporting-with-eazybi

https://eazybi.com/accounts/1001/dashboards/8347-sla-overview

https://eazybi.com/accounts/1001/dashboards/7128-sla-analysis

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/eazy-BI-SLA-Report/qaq-p/1063927

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

0 votes
Gerda Grantiņa
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jun 26, 2023

Hi @Vinay Sharma
First, you should import your "Severity" field as a dimension in your eazyBI account: https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields

Then, if your response time SLA goal is two hours, you could use the measure "Time to first response - Breached" together with "Severity" on Pages for filtering, something like this in the report, this will show you how many issues have breached your defined SLA: https://eazybi.com/accounts/1001/cubes/Issues/reports/81693-time-to-first-response-met-breached-weekly


Best, 
Gerda // support@eazybi.com

TAGS
AUG Leaders

Atlassian Community Events