Getting rid of the duplicate

Grafana
, ,
1

Hi guys
i need to graph a bar graph in grafana. i have this kind of data
hour status | count
|2023-10-30 04:00:00| 10 | 3|
|2023-10-30 04:00:00| 209| 4|
|2023-10-30 04:00:00| 310 | 1|
so i want this data to be grouped by hour but i do not want to have multiple times i just want one 4:00 then all the status and count under that 4:00

2

I used a couple of transformations, i grouped your data by date and time, then i extracted the fields, then i hid the original fields, and stacked them:

image
image1726×1388 91.4 KB

3

thanks a lot. what does your query code look like because i am using code
my code i want to change to look like the one you just posted
SELECT DATE_TRUNC(‘hour’, updated_at) AS hour, status,

COUNT(*) AS count

FROM orders

where DATE_TRUNC(‘hour’, updated_at) = ‘2023-10-30 04:00:00’

GROUP BY DATE_TRUNC(‘hour’, updated_at), status

ORDER BY hour;
can you help me modify it

4

I used a csv file containing the data you provided:
image