On the line chart, when i hover the mouse over the first data point, it reads the other end of the line, and vice versa. If i hover over any data points in the middle, it reads the first data point to the left. Is this how it supposes to work?
Very likely not :)
i rebuilt the data using query order by asc explicity, that fixes the problem.