You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
How to count Jira issues based on a custom field (Severity options High, Medium, Low) when the response time is greater 2h (SLA)?
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.
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.
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 -
Hope this helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Technology Applications Team
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
Gerda // email@example.com