I am using sample data from Training Superstores which is contained in an Excel file.
I want to calculate the profit ratio (profit divided by sales) to see which customer segment and region is doing well.
First I acquire the data and then select Calculate > New Calculated Measure
I select Profit divided by Sales
I wondered about formatting and noticed the following:
There is no percentage.
Now I can create visualizations using the Profit Ratios.
I created storyboards.
Then I published to the cloud