I am pretty confident in Looker, but I wanted to see if there is a better way of doing this. When I have a bar chart that is pivoting on another dimension, I almost always need the stacks to be ordered descending, however, the default behaviour in Looker is to sort based on the values within that particular date. This means that the stacked elements jump around a lot and makes it hard to see consistent change.
So my only options are either to have default sort and the stacks are not organised by volume at all:
Or to have them stacked by volume and then the stacks can look chaotic:
I know that there is a “hackaround” using derived ranking tables, but doing this for every chart and every view is a pain in the butt. I really feel like this is relatively simple and should be a chart setting, not something that requires building and joining yet another view (too many solutions to simple problems require a new view, which overcomplicates models, in my humble opinion, so I would like to se more feature development to address common issues like this).
Any suggestions or an ability to make this a feature request would be great.