Add Sort Transformation

[adeverteuil]

What would you like to be added:

A Transformation to sort series by legend, numeric value, or label value.

Why is this needed:

Prometheus can sort by value, but not by label value. The ordering of series sometimes appears random and changes at every reload. The Stat, Gauge and Bar Gauge panels display series in the order received from the data source. A sorting transformation is needed to present the data in a more readable way.

See also:

• This closed feature request in prometheus/prometheus. This won't be implemented in the Prometheus API.
  Consider supporting sorting by label value prometheus/prometheus#414
• Similar feature request in grafana/grafana. I'm reframing this as a feature request for a new Transformation:
  Gauge & Bar Gauge & Stat Panel should have option to sort each series #17245

[pkolyvas]

We're in the process of moving Grafana feature requests to GitHub Discussions. This issue is being moved to Discussions or has been moved from our issues list, depending on where you're seeing this message.

We hope to use the discussion thread to continue building use cases, and additional evidence based on engagement/voting, in order to help us prioritize this feature request later on down the road.

As with all things Grafana, we value your input and participation in this project and appreciate your patience during this transitional period. Looking forward to the discussion!

[gelicia]

Hello, as you may have heard, we are transitioning away from using discussions to discuss feature requests.

I think this has been implemented - please see https://grafana.com/docs/grafana/latest/panels-visualizations/query-transform-data/transform-data/#sort-by

Feel free to make an issue if this is not a solution and you would like to request a feature.