With this parameter being built as a list of fixed string values, the author of this workbook would need to update the list with the two new sub-categories, then republish this workbook into Tableau Server for them to show up within the list of allowable parameter values. Now to illustrate the value of dynamic parameters, let’s imagine for a moment that this view is in Tableau Server and the Sample Superstore introduced two new sub-categories: Widgets and Gadgets. I also want to note as of Tableau Desktop 2020.3, the version I am using to author this blog, this is the default selection. This means that the values in the list are fixed and will not update dynamically. We can also see in the bottom right of the dialog box there is a radio button that is selected called “Fixed”. We can see that this parameter has a String data type and a list of allowable values. Let’s take a look at the parameter by right-clicking on the Sub-Category Parameter in the Data pane and selecting Edit. So if I change the Sub-Category Parameter to Art, it will highlight the Art Sub-Category. This allows us to choose a Sub-Category and see how it is performing compared to the other sub-categories. In this view I have highlighted a dimension member based on the selection in the parameter and added a reference line for average Sales. To start us off I have connected to the Sample-Superstore dataset and built one of my favorite techniques which is highlighting a dimension member in Tableau on a minimalist dot plot. With dynamic parameters, we can automatically change a parameter value each time the workbook is loaded – and they’re not just useful for dates! In this post, I will show you three must-know ways to use dynamic parameters, including how to dynamically populate a list of allowable string values, how to dynamically update a date parameter to the latest date, and how to update a list of allowable numerical values.ĭynamically Populate a List of Allowable Values This was not an ideal user experience because you couldn’t automatically update a dashboard to the latest date in a dataset when using parameters. Prior to dynamic parameters, parameters were static, meaning that if you had a parameter with a data type of Date, the date would be stuck until a user changed it. Dynamic parameters were introduced with Tableau Desktop version 2020.1 and rightfully created a lot of buzz among Tableau authors due to their automation capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |