I have a list with the below sample data/columns: entry date, location, numeric points field for survey ratings (A=1, B=2, C=3, D=4 and F=5). I have a view grouped by location which won't then let me group by date, but I have sorted on date. I want to add a listview webpart to my report page so managers can select the location of choice and get a small chart displaying the average rating of the points by date by location.
I can't figure out how to sum a calculated column and then average it by the 4 questions per date the survey results will show. Please help!
Survey Focus Area Jan Feb Mar Apr
Responsiveness 1.97 1.75 1.71
Solutions Focused 1.97 1.92 2.00
Resource Availability 1.97 1.67 1.88
Professionalism 1.65 1.58 1.50