how to get number of zero days

[yellow_days]

Hello,

I have a Dataset with a Date of Reviews. Some days are missing, because new comments dont appear everyday. Now I would like to see how many days actually missing. For example I check the dates from 1. april - 5. april and I just have reviews on 1. Apri, 2. April and 5. April. My result should say 2 days.

Can someone give me an advice how I can do this?

best regards

[BhaveshPatel]

You can count the total days in the selected time period using the Date table and then only count the days where reviews happended.

Minus out the Active days from the total days to get the inactive days.

You can use COUNTROWS and DISTINCTCOUNT function to get the job done.

Thanks,

Bhavesh