[TABLEAU] Parameters

Parameters

Parameters are dynamic values that can replace constant values in calculations. For example, you may create a calculated field that returns True if Sales is greater than $500,000, and otherwise, returns False. You can replace the constant value of "500,000" in the formula with a parameter that you can change dynamically using the parameter control. Create a Parameter You can create parameters directly in the Calculated Field dialog box. Click the Create link at the top of the list of parameters. You can also select Create Parameter from the Data window menu, or right-click in the Data window. Define a Parameter Specify the following properties to define the parameter: Name - A descriptive way to refer to the parameter Data type - Integer, floating point number, string, boolean value, date, or date/time Current value - the initial value Display format - How to display the values Allowable values - the type of control used to select values. Parameters can be defined as  an open field (All), a List, or a Range of defined values. Use a Parameter in a Calculation Replace the constant value in a calculated field with a parameter. You can double-click the parameter in the list to add it to the formula. Show a Parameter Control Parameters are global across the entire workbook and are shown at the bottom of the Data window. Right-click a parameter and select Show Parameter Control to open a card where you can modify the parameter value. You can also edit a parameter by right-clicking the parameter in the Data window and clicking Edit.