While I work on this thread, I wanted to know which of the two options you would prefer:
- dotted line replacing the Sundays removed
- simply remove all Sundays
Let me know so I can progress further
IF [DATE] = #1-1-2017# then 'hide'
ELSEIF [DATE] = #12-25-2017# then 'hide'
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Thank you for your assistance. Ideally I could just remove all Sundays entirely, but it's also important--as new data is added every week--that future Sundays are automatically excluded as well.
Thanks for your response. That doesn't work, unfortunately. Because I need to be able to see zero values on Monday-Saturday, I have to turn on "Show Missing Values" in my Date column. So when I try to filter out Sundays it doesn't do anything. For example, if I try to filter out Tuesdays instead, all it does is show each Tuesday at zero records, rather than excluding Tuesdays from the view. Since Sundays are already all at zero, it doesn't change anything. But if I turn off "Show Missing Values" then it won't show non-Sunday dates with zero records. I've attached three screenshots, you can see that the first one (nothing filtered out) and the second one (Sundays filtered out) look the same. The third one I filtered out Tuesdays and Wednesdays, and you can see the chart just places all Tuesdays and Wednesdays at the zero point.
Is there a way to get this filter to override Show Missing Values? THAT would work.
I'm thinking your workbook has Show as Default Value turned on. Change that to Hide Connected Lines.
If that doesn't work could show me in the attached workbook (version 10.0).
256230gv.twbx 1,017.4 KB
I am not sure whether this is something you are looking for. I have attached the workbook with a probable solution. Please have a look and let me know how it goes.
Sunday_Removed.twbx 1.2 MB