Sorting series based graph

1

I use mySQL and monitor data in series based X-axis. My problem is that when ever i refresh graphs, the order of bars change.

How can i sort the bars in alphabetical order?

Thanks!

2

You can add an ORDER BY to your MySQL query

3

I do have order by in my query and still the order of bars is pretty much random

where $__timeFilter(time_sec)
GROUP by your_table.metric, your_table.value
HAVING your_table.value = "value a" or your_table.value = "value b"
ORDER BY your_table.metric
4

Try adding time_sec to the ORDER BY

ORDER BY time_sec, your_table.metric

5

Still the order in grafana changes every time i refresh the tables. mysql host instead shows result in the same order.

6

Ahhh. So you were referring to the bar order. I have the same problem. Boo.

7

did you guys got the solution for this ?

8

Have the same problem