Find missing day in last 7 days

[#1]

Hello,

I have a datetime column,

I want to check, if some date is missing in the last 7 days.

So, I was trying to compare today()-7 = 7th top value, please suggest how can i get it.

OR

suggest if this can be acheived with any other logic.

Thanks,

Deepa v

[prieper]

You may count the number of (DISTINCT) records after TODAY() - 7.

Else have a mastercalendar with all days and check the JOIN for blank fields

HTH Peter

[#3]

Try below,

add dim in chart,

=aggr(only({<StartDate={">=$(=max(StartDate)-7)"}>}StartDate),StartDate)

add exp ,

=if(isnull(StartDate),'Null','YES')