What happened?

‘Order by’ operator should include aggregation columns as sorting option

For example, aggregation is performed on duration, and group by is done by name but only name is available for sorting

What did you expect to happen?

Able to sort on all columns available in query

Did this work before?

No

How do we reproduce it?

1

Is the bug inside a dashboard panel?

No response

Environment (with versions)?

Grafana: 12.2
OS: Windows
Browser: Chrome/Edge

Grafana platform?

None

Datasource(s)?

Azure Monitor