/
How to get the count of high priority issues using Calculated Field in AIO Reports
How to get the count of high priority issues using Calculated Field in AIO Reports
This article helps in creating a calculated field expression to be used to get the high-priority issues.
Instructions
- Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
- Click Create New Field to create a new calculated field.
- From the right-hand side, search for the function IF ELSE and drag the function to build the expression.
- Likewise, drag the function EQUALS and place it in the condition.
- Now drag the Priority field to the value1.
- Within value2, click enter a constant value and input the value as High.
- Input value1 as 1 and value2 as 0.
- Name the calculated field along with a description and validate the field and use it in reports.
Once the above field is used in the Report, which has the Count of issues and the Project Name along with the Calculated field, the result will be shown as below. Here the P1 issues is the Calculated field, giving the number of high-priority issues.
- If you don't want to filter the entire report based on the priority of the issues, then use this expression which will be helpful to display the issue count of the high priority issues as a separate column.
Related content
Best practices to be followed for Power BI Jira Connector refreshes
Best practices to be followed for Power BI Jira Connector refreshes
Read with this
How to concatenate two fields and use them in the AIO Reports
How to concatenate two fields and use them in the AIO Reports
More like this
Import into Power BI - 4.2.1
Import into Power BI - 4.2.1
Read with this
How to show the count of story points of issues in epics with filtered status using the Reports and Timesheet for Jira app
How to show the count of story points of issues in epics with filtered status using the Reports and Timesheet for Jira app
More like this
How to build an expression for calculating % of stories in an epic in particular status
How to build an expression for calculating % of stories in an epic in particular status
More like this
How to get issue count when history fields in a report are used using the Reports and Timesheets for Jira app
How to get issue count when history fields in a report are used using the Reports and Timesheets for Jira app
More like this