Filter dates for the 7 last days with specific criteria

game1 — Mon, 26 Feb 2024 08:40:26 GMT

Hello,

Can somebody help me with this problem?

I want to count the number of persons per day, but only for the last 7 days.

For dates that do not appear in the table, the values will be set to 0. But, I only want that for the last 7 days.

So, for today, it must be in the axis X: from 19/02/2024 to 25/02/2024(Today).

So, I don't want the other dates to appear.

Thanks!

Re: Filter dates for the 7 last days with specific criteria

timalbers — Mon, 26 Feb 2024 08:57:35 GMT

Hi game1
try this for RETURN: IF( Last7DaysCount > 0, Last7DaysCount, BLANK() )

If you don't want a value to appear, it has to be blank, rather than 0.