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.