[chart]sort legends by name or custom sort

[larsmars]

Is your feature request related to a problem? Please describe.
Legends label is not sorted in the same order every time, it depends on count

ie:
Visualization Type: Pie Chart
Metric: COUNT_DISTINCT(unitId)
The count of unitId will determin the sort of legends/labels
The sort order will change over time as the unitId count changes.
Not posible to have static order of legends/labels

Describe the solution you'd like

1. Posible to sort in alphabetical order
2. Dictate sort based on label names (query result)

Additional context
Superset version: 0.36.0

[issue-label-bot[bot]]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.96. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[larsmars]

bump

[curiousus]

I would also like to have the ability to determine the sorting order of the legends in the chart types that can have legends. This is especially useful when working i.e. with data buckets or categories that express a certain gradation (e.g. "minor damage", "considerable damage", "heavy damage" etc).

It would be nice to have this in a future update. :-)

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[adamkarminski]

+1. My use case - I have a time series chart for number of active accounts count grouped by products (~10 of them). I'd like to sort the legend and tooltips by the current active accounts count. I have a calculated field for that and it works fine for sorting an aggregated table, but does nothing in terms of ordering series in the legend and tooltips. 🤷

[antobenve]

I strongly support this feature request and I would like to know if this is planned to be implemented in the future.

[juanmantelli]

+1

[intech]

+1

[aapetrov23]

+1

[Logixqt]

+1

[kangbobi]

+100

[kranoop619]

This would be super helpful when working with buckets

[viniciusmantegazine]

+1

[Senorsen]

+1, any updates here?

[mirzak2001]

+1

[sfirke]

I agree this problem persists in 4.0.0. Here's a particularly egregious legend sort, it's hard to hunt for a particular station # when they are not in alphabetical order:

If anyone in the community wants to take this on, please comment in Slack #improving-superset channel or in this thread.

[konvica]

Mixed chart also does not support reordering of the legend labels. Line chart has this feature as can be see in the picture below

Can something similar be done for mixed charts? (Maybe treat both queries separately).