Filter dates for the 7 last days with specific criteria

[game1]

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!

[timalbers · Accepted solution]

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.