4/11/2023 0 Comments Input attribute tabulo![]() ![]() Note: ELSE accounts for the None value that you included in the parameter, and it returns an empty string.Ĭreate three more calculated fields, one for each of the additional parameters you created: Parameter name WHEN 'Customer Segment' THEN Ĭonfirm that the status message indicates that the formula is valid, and then click OK. In the Calculated Field dialog box, for Formula, build the following calculation: In the Calculated Field dialog box, for Name, type Column 1 Category.Upper right corner and select Create Calculated Field. These steps use the Superstore sample to build the calculated fields that will take advantage of your parameters. Tip: Instead of typing each value in the list, click Add values from > Parameters to add them from Select Column 1 Heading. Repeat the previous step to create the following additional parameters: The Display As aliases default to the field name, and for this exercise you can leave them as they are.Ĭlick OK to return to the Calculated Field dialog box. This article covers only the single data type scenario. You would do this when you build the calculated field, using the STR() function. If you wanted to include a measure such as profit in this list, one option would be to convert the measure to a string value. ![]() These are all dimensions of the same data type (string). Note: This example uses the customer name, customer segment, region, department, and category fields. Complete the list by typing the names of the additional dimension fields that you want to expose through the parameter.This example uses Select Column 1 Heading.įor Allowable Values, select List, type None as the first value in the list, and then press Enter. Name the parameter so that viewers can tell what changing it will do. In the Create Parameter dialog box, complete the following steps: Upper right corner and select Create Parameter. In the Data pane, click the drop-down arrow in the These steps use the Superstore sample to create new parameters. Learn more: See Use Parameters to Add Multiple Views to Your Viz (Link opens in a new window) on the Tableau blog (Link opens in a new window) and multiple practical topics on how to use parameters (Link opens in a new window) on the Data School (Link opens in a new window) website. For a more in-depth presentation, see Parameters | Oh, the places you'll go! (Link opens in a new window) (45 minutes). Use your (Link opens in a new window) account to sign in. Watch a video: To see related concepts demonstrated in Tableau, watch the free training video Parameters (Link opens in a new window) (5 minutes). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |