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!

     

     

     

Sean's avatar
Sean
Community Champion
9 years ago

travbum How is your data organized ? Can you post a sample of your data?

 

If you can set up the Chart like this you should get the result in the top picture!

Axis - Question

Legend - Answer/Response

Value - Your Measure (counting or summing the responses depending on your setup)

  • 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.