Basic question reg. visualization of a survey

[KMZ_ESS]

Dear all,

I wonder whether I'm overthinking this. 🙂 I took some dummy survey data with 5 questions and 3 possible answers each. When I visualize it as a pie chart I'm confused a bit by the terminology (see screen below).

If I drag the answer data into the legend and values fields, the title of the pie is "count of answer by answer". 

If I drag the answer data into the legend field and the question data into the values field, the title of the pie is "count of question by answer". The correct title should be "answer by question", but if I arrange the data any other way the data is not displayed the way I need it.

Now I know I can just edit the title, but wonder whether the way I arranged the data could be a problem if I ever have to create a more complex report. Many thanks!

[Idrissshatila · Accepted solution]

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 👍

Follow me on Linkedin

[KMZ_ESS]

I 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. 🙂