Sort with duration not working properly

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana cloud

  • What are you trying to achieve?
    I am trying to sort the output of a query from the grafana UI and trying to sort the output in table format based on duration, but its not coming in descending format

image

Only the first few entries are getting sorted

  • How are you trying to achieve it?

  • What happened?

Its not getting sorted properly

  • What did you expect to happen?

all entries should get sorted properly

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

2

What is your data source? And is duration a numeric value column in the data source?

3

datasource is thanos with promethues in backend

4

You didn’t answer what data type duration is I would recommenr you use transformation to convert it to numeric