Forum Discussion

travbum's avatar
travbum
Advocate I
9 years ago
Solved

Multiple Stacked Bar Charts

  Is something like this possible? I have a bunch of questions of "Do you agree with X" that I need to be able to display side by side and the following is the best I can come up with currentl...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    travbum As I suspected you have to Unpivot the Data.

     

    With the sample you posted => Edit Queries => select the User ID column => Unpivot Other => Close & Apply

     

     

    Then set up as my original answer!

     

     

     

travbum's avatar
travbum
Advocate I
9 years ago

Sean - I can't say I understand your solution. Here is the data:

 

UserIDQuestion1Question2Question3
0Agree a lotAgreeNeutral
1DisagreeAgreeAgree
2Agree a lotDisagree a lot 
3DisagreeAgree a lotAgree a lot
4 DisagreeDisagree
5AgreeDisagreeDisagree
6Agree a lot Neutral
7Agree a lotAgreeNeutral
8DisagreeAgree 
9 Disagree a lotDisagree
10Agree a lotAgree a lotAgree a lot
11DisagreeDisagreeDisagree
12Disagree Disagree
13AgreeDisagree a lotAgree
14DisagreeDisagreeDisagree
15Agree a lotAgree a lotAgree a lot
16 Disagree 
17Agree a lotAgree a lotAgree a lot
Sean's avatar
Sean
Community Champion
9 years ago

travbum As I suspected you have to Unpivot the Data.

 

With the sample you posted => Edit Queries => select the User ID column => Unpivot Other => Close & Apply

 

 

Then set up as my original answer!

 

 

 

  • travbum's avatar
    travbum
    Advocate I
    9 years ago

    Sean - Excellent answer thank you so much.

  • gorli's avatar
    gorli
    Regular Visitor
    9 years ago

    Hi,

     

    I have a very similar problem. But when I try to unpivot and apply changes I get an error message saying that the ID cannot be double.

     

    Any idea?