I have a look that compares the daily revenue of each previous day compared to that day last week. I use the was in the last two weeks filter as well as this custom filter:
mod(diff_days(date(2008,01,01), now()) + 1, 7)>${transactions.transaction_day_of_week_index}
The issue is that on Monday if I run the custom filter I don’t get the perfect 7 day line up for the last two weeks. If however I remove the custom filter and just the standard was in the last two weeks filter the last 7 days line up perfectly. So to combat this I created a whole different dashboard that has this look with no custom filter that is scheduled to run just on Monday morning. What I want is to have code that would work every day even Monday.
Can someone help write the above custom filter that will basically not use the custom filter if its Monday but do use the above custom filter if its any day but Monday?
LinkedIn
Twitter
