Filtering For Calculated Date

  • 20 September 2021
  • 0 replies


I’m creating a dashboard showing yesterday numbers, however on Monday, I want “yesterday” to actually be Saturday’s data.  

I created a time dimension called yesterday with a case statement that essentially says when date_of_service_index = 0, then date_of_service + interval ‘-2 days’, else date_of_service + interval ‘-1 day’. 

So, I can get the correct date, but how do I apply this to my Explore?  I don’t know how to say date_of_service = my yesterday calculation in my filter.

Maybe there’s a better way to do this from the jump and I don’t need that measure?  I’ve also tried a table calculation, but I end up at the same issue.

0 replies

Be the first to reply!