Wrong order for grouped bar chart sorting (descending)

[oshikryu]

https://codepen.io/oshikryu/pen/xxwxzwm

I'm trying to create a grouped bar chart where the order has the aggregate total of a category going in descending order.

Some notes explaining the chart:

• cloudy should be before rainy when descending

Is there something wrong with the data I have formatted? Or is this a bug with the sorting logic inside of plotly itself?

[oshikryu]

It appears the base case is boiled down to null values improperly being sorted
https://codepen.io/oshikryu/pen/MWaJgLx

[alexcjohnson]

Nice detective work @oshikryu - that part is definitely a bug, we should probably do something like we do in dash-table and always sort null / invalid values at the end, regardless of sort order. I think though that your original use case can be solved without transforms, using categoryorder: 'total descending' https://plotly.com/javascript/reference/#layout-xaxis-categoryorder

[oshikryu]

I will open up a separate issue for the simple case of non-grouped bar chart sorting with null values. The original case of grouped bar sorting still remains unresolved

[oshikryu]

I've updated the example for a much simpler reproduction of the bug. I believe it's either malformed transform or something weird with sorting choosing the first target in a dataset

[oshikryu]

I believe this issue is related to #4711