Forum Discussion
Solved
Data from multiple columns in one visual
I have a survey question: Which of these did you do: A) I did A B) I did B C) I did C which results in a table: I did A I did B I did C TRUE TRUE TRUE TRUE ...
Another way is:
Step 1
Go to Edit Queries
Select your columns with answers.
Transform - Unpivot Columns
Step 2
In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section
Is there no other easier/alternative way to do things? I"ve got like 40 survey questions like this.
Another way is:
Step 1
Go to Edit Queries
Select your columns with answers.
Transform - Unpivot Columns
Step 2
In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section