Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Display an average rating for a distinct choice survey question — Cloud Customer Connect
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
12
Views
2
Comments
edited May 18, 2015 4:45PM in Reporting & Analytics for B2C Service 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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