-
1. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
brain.scott Dec 8, 2011 12:43 PM (in response to brain.scott)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.
-
2. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
Richard Leeke Dec 8, 2011 1:22 PM (in response to brain.scott)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.
-
3. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
brain.scott Dec 9, 2011 1:28 PM (in response to brain.scott)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?
brian
-
4. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
Richard Leeke Dec 9, 2011 3:00 PM (in response to brain.scott)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.
-
5. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
brain.scott Dec 19, 2011 11:52 AM (in response to brain.scott)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.
Thanks.
brian
-
6. Re: Default Filter Selection - Rolling Dates and Blank Dashboards
guest contributor Dec 19, 2011 9:26 PM (in response to brain.scott)Hi Brad,
You can default the date using a Relative Date in the filter.