Display an average rating for a distinct choice survey question

Content

Hi

This is a follow on question to:

"Showing distinct responses for a survey question + frequency of each distinct answer"

https://cloudcustomerconnect.oracle.com/posts/ae65f7ab21

 

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:

Survey Questions: 

Q1: Vehicle Rented  (choice: Bicycle / Motorbike / Car) 

Q2: Vehicle Rating  (choice: 0 / 1 / 2 / 3 / 4 / 5)

 

... and 6 survey responses are submitted:

Responses 

Q1=Car, Q2=3

Q1=Car, Q2=2

Q1=Car, Q2=3