- In a blank worksheet, drag and drop Main provider from Dimensions into the Columns shelf.
- Then, drag and drop Satisfaction overall from Measures into the Rows shelf.
- Hover over the SUM( Satisfaction overall) pill so that a small downward arrow appears on it and click on it.
- Navigate to Measure (Sum), and in the drop-down menu, select Average:
- In the Marks card, change the mark type from Automatic to Circle.
- Double-click on the title at the top of the workspace, and in the Edit Title window, change it from Sheet 1 to Overall Satisfaction per Provider and click on Apply. You will see the title name is changed to Overall Satisfaction ...
