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