Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try below,
add dim in chart,
=aggr(only({<StartDate={">=$(=max(StartDate)-7)"}>}StartDate),StartDate)
add exp ,
=if(isnull(StartDate),'Null','YES')