Hi, I'm hoping someone can help me please.
I have a workbook where users can view the data year on year meaning that it will display all data for current year and the previous two years. Many of the tables and charts show the comparison. The problem we have, is that the values for this year are considerable less than the values for the previous full years. Because of this we would like to set the Week filter to default to select all values up to the most recent full week - currently using week(today())-1.
I have implemented a that allows me to select whether the user wants All data or Year on Year to date, which i then use to set the max week. If they want YOYTD then the max week will be week(today())-1. If the user wants All data then max week will be 52. The problem i have is trying to show the relative week values in my filter based on the output of the calculated field.
Does anyone know the answer or another way that can can switch between All data or YOYTD please?
Thanks,
Kat
Would you be able to provide a sample packaged workbook so we can take a closer look? This will help us to better understand the structure of your data, the charts you’re trying to create, etc. We don’t necessarily need your real data, so if it’s confidential, then perhaps you could try to create some fake data in a similar structure as your real data. Another option is to anonymize your workbook using the technique shown here: Anonymize your Tableau Package Data for Sharing
