-
1. Re: Date filters (parametrs) in incrementaly refreshing extracts
Carl Slifer Apr 26, 2016 2:01 AM (in response to Olya Makarova)Howdy Olya,
You could consider using an LOD expression. Which is set dynamically to your database to learn more about LODs you might consider http://interworks.co.uk/blog/tableau-level-detail-calculated-fields-v9/. The idea would be that for the entire data set we would return the max value and then we would return a value related to that max value. Something like...
[Date] <= DATEADD('day',-1,{FIXED : MAX([Date])}) AND [Date] >= DATEADD('year',-1,{FIXED : MAX([Date])})
What this would do is look through the entire database, including after updates and return the maximum date and then it would only keep anything that's greater than the max date minus a year and less than the max date minus a day. You can set it however you like of course. However dynamically updating parameters is a big need and desire of a lot of people. Help us out and vote for it here. Dynamic parameters as it is not a current feature that is supported by Tableau at this time.
Cheers!
-
2. Re: Date filters (parametrs) in incrementaly refreshing extracts
Łukasz Majewski Apr 26, 2016 2:51 AM (in response to Olya Makarova)Your continuous date filter - a slider I guess - will have new dates after refresh but you must clear the filter (it must include 'All')before saving/publishing. Any quick filter works this way if saved as cleared.