You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Display an average rating for a distinct choice survey question

Accepted answer
edited May 18, 2015 4:45PM in Reporting & Analytics for B2C Service 2 comments



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:

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:

Q1=Car, Q2=3
Q1=Car, Q2=2
Q1=Car, Q2=3

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!