Forum Discussion
Helper IBasic question reg. visualization of a survey
Hello KMZ_ESS ,
If you want to see each question how many answers it has, the question column should be in the legend and the answers in the value section.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Super UserHello KMZ_ESS ,
If you want to see each question how many answers it has, the question column should be in the legend and the answers in the value section.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
KMZ_ESSI had tried that before. See below what happens. It counts all answers, not each answer separately. I don't need the total sum of answers as that is the same as the number of questions. The first 2 pies in the above screen show what I'm looking for. I want to know:
- for question 1 how many have answered 1
- for question 1 how many have answered 2
- for question 1 how many have answered 3
- for question 2 how many have answered 1 etc.
I'm using the slicer to switch between questions. It doesn't make sense to have all questions at once in a pie. Especially if the possible answers to each question are different. In this case I just used simple dummy data where the possible answers are the same for all questions.
My question is more regarding the title. Is there a way to get the data displayed as in the first 2 pies above and have the title "answer by question"? I understand I can change the title manually but wonder whether there is something I did wrong that makes the title either "answer by answer" (first pie above) or "question by answer" (second pie above).
- KMZ_ESS
I think I just figured it out. Of course "answer by question" counts all answers. I actually have to insert answer both in legend and values, then it counts the number of answers for each answer. The title then is "count of answer by answer" and now I'm pretty sure the title has to be changed manually in any case.
The mistake was a conceptual one in my head. "Answer by question" is what it may be called colloquially, but not logically. 🙂