Display an average rating for a distinct choice survey question
This is a follow on question to:
"Showing distinct responses for a survey question + frequency of each distinct answer"
Summary: We want to show the distinct values for a survey question in Column A, and then in Column B display the average of another survey question for all users who chose the value from Column A.
For example, lets say I have 2 questions:
Q1: Vehicle Rented (choice: Bicycle / Motorbike / Car)
Q2: Vehicle Rating (choice: 0 / 1 / 2 / 3 / 4 / 5)
... and 6 survey responses are submitted: