→From the Data pane, under Parameters, right-click the Churn rate % and Growth % parameters and select Show Parameters →From the Data pane, drag the Forecast Sales in the table that you created →From the Data pane, drag the Sales measure to Text, under Marks →From the Data pane, drag the Region and Segment dimensions to Rows →Right-click the Year(Order Date) in the Filters Pane and click on Show Filters, on the right side you will find the Year(Order Date), here, click on the right side of the panel and select Single value list
→Drag the Year (Order Date) from the Columns into the Filters Pane and select Years, Click Next, Select ALL, then press OK
TABLEAU PREP CALCULATED FIELD PLUS
→From the Data pane, drag the Order Date dimension to Columns and click on the plus sign until you open Year, Quarter, Month *(1+)*(1-) Step 3: Create the table and bring the parameters in the view →In the formula field, create a calculated field similar to the following, and then click OK: In the example workbook, this field is named Forecast Sales →In the Calculated Field dialog box that opens, enter a name for the field. →Select Analysis > Create Calculated Field to create a calculated field →Create another Parameter by following the steps above and Name it Churn Rate % and under Range Values change the Minimum value to 0. →Under Range values change the Minimum to -1, the Maximum to 1 and Step size to 0.01 and then click Ok. →Change the Display format: from Automatic to Percentage →In the Create Parameter window, change the Name to Growth % →From the Data pane, create a Parameter (use the small triangle near the search bar) Step 2: Create the parameters & Calculated fields
In Tableau Desktop, connect to Sample – Superstore sample data provided by Tableau. If you like video tutorials, follow the recording of the entire process of creating a What-If analysis as you can see in the #skillpill video below, by our colleague Dragoș Cojocaru, Data data analysis! Here are the written steps: Step 1: Connect to data When the value of a parameter changes, also the result of the view changes.
TABLEAU PREP CALCULATED FIELD HOW TO
Discover what can powerful parameters do for your data visualization and at the same time learn how to create a What-If analysis in Tableau.
0 kommentar(er)
