Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating a basic 100% stacked bar chart

I thought it would be easy, but I'm having some trouble creating a 100% stacked bar chart.

 

My simplified dataset is at a granularity like the following. It represents a response's score for a question:

Question Name | Score

question1                 3

question1                 2

question2                 1

question2                 2

question2                 3

question2                 4

 

Where the range of score is 1-4.  I was hoping to make this 100% stacked bar chart organized by question, and shows the count of responses per given score. So in my sample data set, question2's bar chart would show 4 bars each at 25% since there are 4 responses, all with a different score. And Question1 would be a split of 50% to Score=3 and 50% to score=2

 

I've put the Question field in the Axis, and score as the legend, but the legend is showing a distinct legend for each single record in the table like this:

 

It's also not grouping all the same scores together. The question that has the 33% splits has all scores of 2, so it should be just 100% of 1 color/score.

4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    What have you got in the 'Value' section? It should be Count of Score.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

    According to your snapshot, your graph seems summarize on 'count' mode, please double check your table structure to confirm score column is configured as numeric type.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yep, the value is 'Count of Score' and I've confirmed that it's a numeric data type, specifically whole number.

      Any other ideas as to what's going on?

      • HotChilli's avatar
        HotChilli
        Community Champion

        Please attach a picture of the right hand side of the report when the 100% stacked bar chart is selected. We need to see the fields.