eazyBI: How do I include 0 values when using transition status dimension?

[David Powell]

Hello.

I want to report on how long my tickets are waiting for a response from my customers (which I track by using an issue status "Waiting for customer").  So, I put "Transition Status" into the "Pages" section and use the "Workdays in transition status" measure.  I use "Issue" as my rows.  In order for that to work properly, I need to filter the transition status to "Waiting for customer."  This gives me the proper calculation, but it excludes all of the rows where the ticket has not ever been in the "Waiting for customer" status.

I don't want to exclude those issues.  I'd like to have a history of the different issues and see all of the issues, including the ones where the time waiting for customer would be 0.  How do I do that?  I know that I can click the "Nonempty" button on the rows, but then that would prevent me from doing any other filtering.  I'd like to have a "Reporter" filter as well, so I can look at my different customers and see their tickets and how long we've needed to wait for them to respond to them, even if that amount is 0.

How do I pull this off?

Thanks.

[Janis Plume (eazyBI)]

Hi,

You can use the CoalesceEmpty function to show zero values instead of the empty:

CoalesceEmpty([Measures].[Workdays in transition status],0)

Best regards,

Janis, eazyBI support