Non continuous time graph

Grafana
1

Hi,
I’m using Grafana 4.3 and backend MySQL DB. Here is my SQL query return for particular Device:

And here are results:

123.JPG1891×753 77.4 KB

Why it is displaying back in time?

2

Oh, got it, maybe it is not sorting time automatically

3

It is just an sql query. Here is the template you get when you create a new query and you can see it has an order by:

SELECT
  UNIX_TIMESTAMP(<time_column>) as time_sec,
  <value column> as value,
  <series name column> as metric
FROM <table name>
WHERE $__timeFilter(time_column)
ORDER BY <time_column> ASC