1 of 1 people found this helpful
You can get the average of each by creating a calculated field like AVG(IF Group = 'Satisfaction' then Response END). Then do the same for importance and finally create a field which subtracts one from the other.
I tried your suggestion:
Satisfaction = AVG(IF Group = 'Satisfaction' then Response END)
Importance = AVG(IF Group = 'Importance' then Response END)
Gap = [Satisfaction] - [Importance]
But having difficulty displaying the three charts side by side, or for that matter displaying it side-by side with any of the charts!
Upload your sample and explain what you're trying to achieve. Are you creating multiple worksheets and putting them side by side on a dashboard? Or are you trying to achieve 'side by side' by using multiple metrics in the same workbook?
My sample was uploaded with my original question.
In my sample I have Importance and Satisfaction side-by-side in dashboard, only because I don't know how to have them side-by-side in a workbook. I would prefer to show all metrics side-by-side in the Workbook.
At this point, I can live with displaying 'Gap' side-by-side in dashboard.
Best case everything 'side-by-side' in workbook.