Chart not showing data correctly

[pldmayer]

Hi, I am trying to implement a chart into the screen, I have a external Mysql DB with a simple table

Then I write a query ordered by ID

but when I link the query to the chart the labels get mixed up

Any Idea how I can resolve this issue??

[mjashanks]

Hmm, it seems like it is ordering alphabetically. To work around this, you could use SQL to convert the month values to 2021-04, 2021-05 (alphabetically ordered months). Not ideal, but it will get you moving forward for now.

[aptkingston]

I replied this morning in the issue you created here: #1499, but I'll copy my response from there:

Hi @pldmayer. Currently the charts sort data by their X axis (label column) which is usually desired for time series data, but not in all cases as you've highlighted. Our release coming out next week has huge improvements in it for searching and sorting data, which will let you sort your data however you want and have that properly reflected in charts.