Rendering time series requires to to sort the results

[nadav-dav]

What happened:
When rendering the ADX results in a Time Series, you have to manually add | order by timestamp asc or the ADX won't render correctly

What you expected to happen:
If sorting is required, it can be done by the ADX plugin in client side.

How to reproduce it (as minimally and precisely as possible):

1. Open Explore page
2. Select ADX datasource
3. Select "Format as: Time Series"
4. Run a query like:

Table | where timstamp > ago(2d) | summerize count() by bin(timestamp, 1h), label

5. You'll get an error: detected long formatted time series but failed to convert from long frame: long series must be sorted ascending by time to be converted. Returning table format instead.

Screenshots

Anything else we need to know?:

Environment:

• Grafana version: 11.1.4
• Plugin version: 5.0.6
• OS Grafana is installed on: on-prem
• User OS & Browser: Chrome
• Others:

[aangelisc]

Thank you for opening this issue @nadav-dav, can confirm I've replicated this if there are more than two columns returned. We could look at ordering provided it doesn't have any unexpected side effects.