Forum Discussion

travbum's avatar
travbum
Icon for Advocate I rankAdvocate I
9 years ago
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       ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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

     

travbum's avatar
travbum
Icon for Advocate I rankAdvocate I
9 years ago

Is there no other easier/alternative way to do things? I"ve got like 40 survey questions like this.

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

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