I’m creating a survey to be distributed to 30 different sites. I want each site to be able to benchmark their survey responses against all of the other sites. However, I don’t want to compare the sites against everything in aggregate-I want to compare the weighted average of each site.
Essentially, the benchmark should be calculated like this (but with 30 sites)
| Site 1 | Site 2 | Site 3 | Site 4 |
| 4.2 | 3.5 | 4.8 | 2.7 |
(4.2+3.5+4.8+2.7)/4 = 3.8
The only way I can see to do this is to create a custom metric for each question which is going to be more time consuming than I’d like. Am I missing an easier way to accomplish this?
