Table Panel column not sorting number values

Grafana
1

Trying to get a number value to sort correctly in a Table Panel, but numbers are being sorted as though they are string values–screenshot:

crash
crash601×576 30.3 KB

Using SimpleJSON datasource, whose output looks like this snippet:

[{"columns":[{"text":"Affected Users","type":"number"},{"text":"Application","type":"string"},{"text":"As of Date","type":"time"},{"text":"Crash","type":"number"},{"text":"CrashFree Sessions","type":"string"},{"text":"CrashFree Users","type":"string"},{"text":"Device Region","type":"string"},{"text":"Duration","type":"string"},{"text":"_id","type":"string"}],"rows":[["2","XXXX","2018-5-03 00:00:00","2","99.95%","99.7%","iOS_US","Last_30_Days","XXXXXX"]...

Please, am I doing something incorrectly with the data or the configuration in the panel? Many thanks.

1 Like
2

The source of the numbers are in string format so that’s why they’re sorted that way.

If you find this feature really helpful I would suggest you to open a feature request issue.

Marcus