If I understand your question, you are looking for a way to dynamically update the parameter so it reflects new/changed values in the underlying data. Unfortunately, this is not possible in Tableau 7, and adding this function is currently the 2nd most-voted for feature in the Ideas section: http://community.tableau.com/ideas/1178.
does 8.1 allow u to automatically update parameters when extracts are refreshed? or any other work around?
I would also like to know if automatically updated parameters are in 8.1.
8.1 does not have this functionality. Jonathan has posted a method using data blending on his blog, but we all hope to see this built into Tableau soon.
So we have to use some complicated work around in order to complete a simple task... Yeah no thanks. How is this not a feature? I'm becoming more disillusioned with Tableau the more I work with it..
Hi Jonathan, the link to the idea is dead. Any idea on how we can continue upvoting this? Thanks!
Has this problem been solved in Tableau 9.3? I have the same problem in 9.3.
We are looking for this feature but we are using custom SQL and that is why dynamically parameter list won't be updated due to the caching issue. Here is the detail from the Interworks URL link https://www.interworks.com/blog/rcurtis/2016/04/20/tableau-deep-dive-parameters-parameter-overview
Parameters & Custom SQL
Did you know you can use a parameter inside of your custom SQL statement? This feature first appeared in Tableau 8. We caution people when they use custom SQL. Make sure you know what you’re doing, because you can break your workbook very quickly.
Tableau has its own query language that it uses to connect to the data source through a driver. When you write custom SQL, it’s included in Tableau’s query language as a subquery. Your query does not operate in a vacuum for this reason. You can have unintended consequences by not understanding the context around your SQL.
For parameters, the versatility of multiple values within a single variable can create performance issues all on its own in the SQL. Tableau caches the query to optimize performance, and if your user is changing values within the parameter, it’s possible that Tableau won’t have a cache for it. Try to limit your parameters inside of custom SQL use for frequently used parameters or parameters with a limited membership of values.
For more help on optimizing your parameter use within your worksheets, check out Workbook Tools for Tableau. There are two tools within the suite that will help significantly: the Performance Analyzer and the Best Practices Tool.
I hope this will help.
if this is 2nd most voted ideas for quite some time, has it been made available in 10.0?
what can users do to get this feature added?
I am exactly stuck with the same problem.
1 of 1 people found this helpful
I would also like to know if this feature has been added. This is such a simple yet highly desired functionality.
interested to know how the 10.3 quick filter for the latest date helps for the parameter freshing!!!
Are there any updates regarding this feature request? I cant seem to find anything in the requested feature section regarding the topic.
edit: Here's an updated link to the feature request:
Any update-need this feature badly...
Hello Aakash and all Folks waiting for Autofill for date parameter,
I might have a solution to your problem, but I am unsure how it would affect end user experience.
You can create a dummy data with 0's for future months/future dates and populate the filter. When user selects until the max date / current date, they will see the actual data but when they select future dates, they will see blank sheets.
this is a temporary solution and hopefully tableau solves this issue soon.