Hi,
I’m trying to calculate a metric for issues done %. It’s different from the ‘Issues resolved %’ as it should exclude issues in ‘Cancelled’ status (the resolution date gets set for these so they’re included in the ‘Issues resolved’ measure). How can I get this accomplished?
Here is ‘Issues resolved %’
CASE WHEN
[Measures].[Issues created] > 0
THEN
CoalesceEmpty([Measures].[Issues resolved],0)
/
[Measures].[Issues created]
END
Thanks!
Hi @sgoljer
Is the “Cancelled” a Status or a Resolution value?
If it is a Status value, you can add the Status dimension as a Page filter in your report and define a new calculated member in the Status dimension with the following formula:
Aggregate(
Except(
[Status].[Status].Members,
[Status].[Cancelled]
)
)
Use this member to filter your report:
If Cancelled is a Resolution value, you can do these same steps with the Resolution dimension.
Best regards,
Nauris / eazyBI support
1 Like