Comparing one to everything else

In this recipe, we will create a bar chart that shows how much more or less other athletes earned compared to a selected athlete.

Getting ready

To follow this recipe, open B05527_03 – STARTER.twbx. Use the worksheet called Compare one against everything else and connect to the Top Athlete Salaries (Global Sport Finances) data source.

How to do it...

The following are the steps to create a chart that allows a selected item to be compared with all other items in the view:

1. Right-click the arrow beside the Dimensions section in the sidebar, and select Create Parameter.
2. Create a string parameter called Compare salary with the following settings:
   
3. Click on the Add from Field button, choose the data source Top Athlete Salaries (Global Sport Finances), and then select Athlete.
   
4. Click on OK when done.
5. Show the parameter control for Compare salary with. You can do this by right-clicking on the parameter, and selecting Show Parameter Control.
6. Create a calculated field called...