Good afternoon, I am doing an evaluation questionnaire system, where you have several questionnaires with several questions that refer to a questionnaire, which can be opened or closed.
In the response table where I'll pull reports, it works with the following fields: ID / RESTRICT ID / RESPONDENT / QUESTION ID / QUESTIONNAIRE / QUESTIONNAIRE / TYPE / RESPONSE
What I want is the following, to get the amount of answers with value 'Very Good', 'Good', 'Bad,' Very Bad ', Example:
Question / Answer / Quantity
Question 1 - Very good - 3
Question 1 - Good - 4
Question 2 - Very good - 5
Question 2 - Good - 2