CASE WHEN [Measures].[Issues created] > 0 THEN CoalesceEmpty([Measures].[Issues resolved],0) / [Measures].[Issues created] END

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