I'd add that this starts happening a week after I push a build of the workbook out to the server. In other words, if I changed the workbook and pushed it out to the server today, with 12/8 selected in the radio button, tomorrow the manager could log in, and 12/8 ('yesterday', on 12/9) would be selected, the data for 12/8 would paint. But once a week goes by, I've got no data and no radio selected and nothing paints at all.
How about a "Show data from N days ago" parameter and then a filter on a calculated field based on that parameter? The calculation would be a boolean calculated field something like this:
[Date] == TODAY() - [Days Ago Param]
Just put that on the filter shelf and select True.
Default the parameter to 0.
Hi Richard -
Your solution works, but I have my concerns that my data consumers are going to figure out something that doesn't give them a date value to pick.
I can't believe this hasn't popped up here and/or the Tableau team hasn't tried to build a dashboard on data that changes daily or hourly and wanted an up to speed default value.
Any other ideas from the gurus?
Yes I agree about it being ugly - I tried to think of a way to present it as a date. This has come up before and I don't recall a better answer.
Hi Richard Leeke (or anyone) -
I've been thinking about this problem on and off for a while and haven't come up with a solution, much to the humor of my consumers. Tableau support didn't really help, indicating they'd ask the technical team to consider dynamic parameters in future releases.
My eventual destination is Tableau Server. Is there a tabcmd based solution that might help me here; i.e., can you ask tabcmd to recreate a parameter list? If so, I could (should be able to) tie to my date on the datasource and be golden. I'll also ask the server forum.
You can default the date using a Relative Date in the filter.