I have to prepare a data model for survey data in which we have a excel file which contains all responses from user, question details and possible response values.
There are single response and multi response questions in survey
Now I want to show some statistics in terms of bar graph.
Requirement1: For q1 I want to create a bar graph showing count of users based on gender (gender on x axis and count on y axis).
Requirement2: For q2 I want to create second graph showing count based on subdesc (subdesc on x axis and count of users having response value 1 for every subdesc).
What could be best approach to design this in QV. This is only sample data for two questions.
It would be very helpful to get expert suggestions on this scenario.
see the attachment.
Thanks for your response.
I want to make generic as I have list of questions and some questions have more than 10 sub questions.
Its not only Gender that I could write in load script.
You should start thinking about your datamodel. Based on the info you give I'd suggest you create a fact table for all the surveys and users IDs (I'd recommend also storing dates).
You can then create dimension tables for the users and the surveys. Each question will have it's row with the value filled in.