How to exclude current (incomplete) week from card

JaBo1256

I am building a card that show number of visits at our practice.  I would like to exclude the current week from the report as it is incomplete.  I see other posts on how to to exclude the current month but nothing on week.  Can someone show me the beastmode that will work for week?

 

Thanks!

BlueRooster

Here you go, something like this should work:

 

CASE WHEN WEEK(`Date`) = WEEK(CURRENT_DATE()) AND YEAR(`Date`) = YEAR(CURRENT_DATE()) THEN 0 ELSE 1 END

Set this as a filter and have it = 1. This will allow any date that does not fall on the same Week # and Year as the current date to be included in your data.

 

Let me know if you need anything else,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.