Follow along the exercise steps:
- In Tableau, select New > New to create a new workbook.
- In the new workbook, select Data > New Data Source and connect to the Sample Superstore dataset located in My Tableau Repository/Datasources.
- Connect to the Orders worksheet.
- Create the following parameters:
Parameter |
|
Name |
Select Sufficient Profit Ratio |
Data Type |
Float |
Allowable Values |
Range |
Min/Max |
0.25 - 0.5 |
Step Size |
0.01 |
- Create the following calculated fields:
Name |
Calculation |
Profit Ratio |
SUM([Profit])/SUM([Sales]) |
This Year's Profit |
IF [Profit Ratio] > [Select Sufficient Profit Ratio] THEN "Sufficient Profit" END |
Window Sum |
WINDOW_SUM(SUM([Sales])) |
Profitable? |
[Profit] > 0 |
- Right-click on the data source and select Extract data.
- Click the...