Numeric column in data table not sorting accurately

Grafana
1

Hi,

I’m having some trouble sorting a column of data in a table panel. As you can see in the data inspector, it is not sorting correctly (both ascending and descending). It is not in any order without any sorting applied either. The behaviour is the same in the table itself too.

image
image280×1446 15.9 KB

The JSON panel data seems to show the data is in the form of numbers rather than strings.

image
image672×1888 147 KB

Any thoughts would be much appreciated. I am relatively new to Grafana - and working on databases generated by someone else - so I could be making a simple mistake.

Thanks :slight_smile:

2

Hello @ed13aines, there is currently an open issue on github for Grafana 7: Table sorting issues. You can follow that issue and/or changelog to find out when this is fixed. :slight_smile:

3

Thanks very much. I searched but couldn’t find any similar open issues.