olek
1
Hi!
I created a query where I display count of statuses grouped by hour.
SELECT date(created), hour(created) as hour, STATUS, COUNT(1)
FROM trades
WHERE created >= now() - INTERVAL 21 hour
GROUP by date(created), hour, status
order by date(created) asc
The resulting table is correct:
But the sorting order in the visualization is wrong:
k4s1m
2
I think this is the same issue shown here:
Does the explanation I wrote there solve your problem here?
olek
3
Hello, thanks for your answer. It seems more or less clear how to do you when you have 2 data set (like red and blue), but in my case I may have many different statuses so not sure what to do.
k4s1m
4
The idea is to write your query so that every combination is listed. I usually do this by UNION with several CTE’s so that every trace has a value supplied for every y axis value.
