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.
This is exactly what I was going to suggest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Jira Administrator
Configure Jira Software, Jira Core, or Jira Service Management, including global settings, permissions, and schemes.
Managing Jira Projects Cloud
Learn to create and configure company-managed projects in Jira Software and partner effectively with Jira Admins.
Learning Path
Become an effective Jira Software Project Admin
This learning path is designed for team leaders who configure Jira Software projects to match a team's processes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.