In my report I need a number of dropdowns which are to be used to run a stored proc which will be used for generating the report. Is there a way I can dynamically populate the dropdowns (parameters) which will then call stored proc when we change its values?
One of the dropdowns is a Reporting Period Selection. So hardcoding values in parameter is a no go as it will then require manual update in production to add the new reporting period every month,
Hi @Manoj Menon ,
You can use a field in your dataset, or even a custom query (published as a new datasource) to 'fill' the parameter when the workbooks opens (or the dashboard is loaded on Tableau Server).
Have a look at Dynamic Parameters (and read the blog post @ https://www.tableau.com/about/blog/2020/2/say-hello-dynamic-parameters) - is this what you are looking for?
Kind regards,
Johan de Groot
