How to count Jira issues based on a custom field (Severity options High, Medium, Low) when the response time is greater 2h (SLA)?
This is exactly what I was going to suggest.
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.
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
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Become an effective Jira admin
Manage global settings and shared configurations called schemes to achieve goals more quickly.
Streamline Jira administration with effective governance
Improve how you administer and maintain Jira and minimize clutter for users and administrators.
Learning Path
Become an effective Jira software project admin
Set up software projects and configure tools and agile boards to meet your team's needs.