Bar Chart not showing bars in desired order

Looker Q&A Looker Studio
1

Hi!

I want my bar chart to display the bars in the following order from left to right: Very Satisfied, Somewhat Satisfied, Neither satisfied nor dissatisfied, Somewhat dissatisfied, and Very dissatisfied. Since my data is text, I went back to my Google Sheets where I have my raw data and added a column to number each data point in column B2:

Google Sheets column (this shows only part of the column as an example):

looker_studio_overall_satisfaction_formula.png
looker_studio_overall_satisfaction_formula.png180Ɨ585 3.78 KB

Google Sheets formula:

looker_Studio_google_sheets_formula.png
looker_Studio_google_sheets_formula.png532Ɨ153 16.1 KB

However, my bars are still not showing up in the order I specified in my Google Sheets formula. It looks like this:

looker_studio_bar_Chart_wrong_order.png
looker_studio_bar_Chart_wrong_order.png520Ɨ398 3.13 KB

  • Dimension - set to the right survey question
  • Metric - Record Count
  • Sort - column from Google Sheets that quantifies my text data. I also have it set to Ascending order

I have asked Gemini for help and have trouble shooted but no luck. Iā€™m hoping someone can help me figure out what the underlying issue is. Thank you!

2

Hi,

For the column you use to sort, if it is aggregated as a SUM, it should be aggregated as AVG, or MIN, or MAX instead.

Beginner_0-1750350627376.png

1 Like
3

Thank you so much, that worked! Appreciate your help :slightly_smiling_face: