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

Visit Redwood Community
Showing distinct responses for a survey question + frequency of each distinct answer — 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

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

Accepted answer
12
Views
3
Comments
edited May 18, 2015 2:55PM in Reporting & Analytics for B2C Service 3 comments

Content

Hi - I'm hoping someone can advise as I'm not seeing an out of the box report that can be easily customized to support this.

 

Summary: We want to pull a list of distinct values from the responses to a specific survey question, and then show the frequency for each of these over a time period.

 

For example, lets say I have 3 questions:

Survey Questions: 
Q1: Vehicle   (choice: car / boat / plane) 
Q2: Make/Model  (free text entry) 
Q3: Colour   (choice: red / blue / yellow) 

... and I have received 5 responses to the survey:

 

Responses 
Q1=Car, Q2=Ford, Q3=Red, Date: 2015-03-01 
Q1=Car, Q2=Porsche, Q3=Yellow, Date: 2015-04-12 
Q1=Plane, Q2=Boeing, Q3=Blue, Date: 2015-04-23 
Q1=Plane, Q2=Airbus, Q3=Blue, Date: 2015-05-01 
Q1=Boat, Q2=Airboat, Q3=Yellow, Date: 2015-05-03 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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