You need to make a calculated field:
Here is original one with blank day:
Make a calculated field: weekday with sales:
IF [Sales]!=0 THEN [Weekday]
Use this instead of weekday, and put it in filter, uncheck "Null" in the filter, you will get the desired result:
Hope it helps.
we.twbx 9.4 KB
Thanks man! I just have one question about that. Where is the field [Weekday] coming from? Is that just a field you have in the data? I am currently using a normal date and just organizing it by weekday within Tableau. Is that still going to work?
Just kidding, I figure it out. I just needed to use DATENAME('weekday',[Date]) in a calculated field so that I can do it the way you described above.
Thanks a ton!
Also, another way that I figured out how to get it to work is to just filter out today.
For example, I have my Date field filtered to WTD. And then I created a calculate field [date] < Today() and set it to true in the filter.