How to display the mean value of a total instead of average?
I have a dataset where I am counting Completed Surveys, Total Survey Score, and 5 Scale Conversion. I am trying to display the mean value of the 5 Scale Conversion, for example -
Completed Surveys = 114
Survey Score = 427.30
5 Scale Conversion = 534.13
Result when I enter into a calculator 534.13 / 114 = 4.68535 or 4.7. When the AVG is used in a graph of the scores or if MIN/MAX/AVG is displaying, it displays as 4.82. My boss says in her Turrets style, you cannot average an average so I am at a loss as to how to display this information.
Here is the first attempt at a Mean Survey Score -
SUM(`SurveyScore`) /(CASE when `CompletedDateTime` > '01/01/1901' then 1
Thanks in advance!