Tableau doesn't support this. You need use parameters and calculation to achieve similar function.
For example, you have a parameter called [Customized Date] with two values, 'customized' and 'by default' and set the default value as 'by default'.
And create a calculation field according to the value of parameter determine its value. something like
if [Customized Date] = 'by default' then
your calculation value express
If you could provide a sample workbook will be much easier to show step by step
Thank you for your answer.
I cannot send you the workbook as I am working with a live database sadly.
I don't quite understand how your formula would work in my case. I tried to adapt it a bit to see if I could make it work, without much success so far. This is basically what I tried to do :
if ISNULL(DATEPART('weekday', [Date de réservation jours alignés])) then
DATEPART('weekday', [Date de réservation jours alignés]) = 06072018
The calculation seems valid, but it doesn't update my filter (named Date de réservation jours alignés) to 06/07/2018.
1 of 1 people found this helpful
It not necessary to be your real data in your data source, make up some dummy data but keep similar structure as your data source, but can reflect your issue.
Otherwise it is not easy to explain
Thank you for your answer. You can find enclosed a dummy workbook with what I am trying to do.
Basically, having my dashboard defaulting to the day before today, while letting the end user change if he wishes too.
EDIT : Changed the workbook to better reflect my real dashboard.
Data filter day.twbx 40.7 KB
I kinda solved the issue by using the solution from this thread.
The problem now is that I cannot select multiple values (ie Monday and Friday) from the parameter, I am only able to select single value (Yesterday, monday).
Thanks for the workbook and please find my workaround attached.
Below is the steps
1st, create a parameter with two list values, Default and Customized
2nd, create two calculation fields shown below
3rd, create two worksheets, one for customize display, and one for default
add the filters as shown below
4th, in the dashboard, drag the two worksheets into a titled container and hide the report title for each sheet.
Hope this helps, let me know if you have question.
Data filter day_v10.2.twbx 43.8 KB
Thanks a lot Zhouyi Zhang ! It is a bit hacky, but it works. Thanks also you for the detailed explanation.
I still think I will not use this solution because I have lots of sheets in my dashboard, and with this I would need to duplicate them all. Also, when needing to change a sheet, I would need to make the change in the duplicated one, etc.