Show [0] for dates without values

sgrobben — Mon, 20 Dec 2021 21:08:46 GMT

I have a table on a sheet which displays the values per day of the month. As a dimension i use a master calendar which shows all the days within a specific time frame (f.e. 01-06-2020 till 30-06-2020). As a measure I have the following expression:

Count({<TransactieType = {'OpnameMut'}, [OPNMUT.CoronaTestStatus] = {'P'}, HerkomstInstelling = {'nb'}>}Distinct OpnameNummer)

This gives me a result as shown in the attachment. As you can see the dates between [06-06-2020] and [24-06-2020] are missing because there is no data that can be found. Is there a way to show the dates and show 0-values as a result?

Any help is much appreciated!

Re: Show [0] for dates without values

sgrobben — Fri, 30 Oct 2020 09:09:09 GMT

Found the solution already, is it done by using the relative simple expression:

Count({<TransactieType = {'OpnameMut'}, [OPNMUT.CoronaTestStatus] = {'P'}, HerkomstInstelling = {'nb'}>}Distinct OpnameNummer)

+(0*Count({<TransactieType = {'OpnameMut'}, Datum = {"<=$(vBeginDatumToday)"}, HerkomstInstelling = {'nb'}>}Distinct OpnameNummer))

topic Show [0] for dates without values in App Development

Show [0] for dates without values

Re: Show [0] for dates without values