Bar chart with Other bucket on bottom

David_Fickes · 01-20-2021 09:23 AM

I’m porting over a dashboard that has two stacked bar charts. The top one is a 100% chart showing share of wallet for various items. The second shows actual spend volumes. Pretty useful to show changes over time.

The request has been made to port this view to looker. The gray portion showing (~52%) is the OTHER bucket which I want to have down on the bottom as a baseline. I’ve looked at trying to sort but it seems all I can do is sort ascending or descending and I can’t order it with the 350 item Other bucket at the bottom on its own where it belongs.

Suggestions?

mathias_luyten

What you could give a try is changing the name of OTHER to for example aa_other.
This would make it possible to get it at the bottom when sorting.

You can then change the displayed name in the legend back to OTHER by overwriting it.

In order to do this you go to edit → series → customizations → Label

It is a (not so clean) workaround, but should work

Dawid

Since Other is the biggest bucket, why ordering it with DESC wouldn’t work for you? If not then what @mathias_luyten suggested is your only option. If you can’t change the label because that’s what it comes as from the source, you may need to create a Custom Dimension:

if(${view.field} = “Other”, “aaaa_Other”, ${view_field})