I have a report showing team names as rows, and various columns for the teams. I just cant get a count column to show of the issues they’ve had where the satisfaction score is less than 3.
I’ve tried Aggregate, Count, Sum but always get errors.
I have a report showing team names as rows, and various columns for the teams. I just cant get a count column to show of the issues they’ve had where the satisfaction score is less than 3.
I’ve tried Aggregate, Count, Sum but always get errors.
Hi @Terry86,
In your case, the key is to use the dimension “Satisfaction” to group issues by their satisfaction value. If you do not see this dimension in the Analyse tab, go to import options and select the Satisfaction field for data import as a dimension (Jira Service Management custom fields).
In Measures, define a new calcauted measures to count how many tickets have satisfaction less than 3. The expression that looks like below"
Sum(
--set of satisfaction rates below 3
{
[Satisfaction].[1],
[Satisfaction].[2]
},
--sum up issues with listed satisfaction rates
[Measures].[Issues with Satisfaction created]
)
In the example, the measure “Issues with Satisfaction created” shows issue count by issue creation date when filtering report data by Time. If you want, you can use other measures “Issues with Satisfaction resolved” or “Issues with Satisfaction date” to filter issues by resolution date or date when they were evaluated.
More details on calcauted measures are described in the deocumentation: Calculated measures
Best,
Zane / support@eazyBI.com