Hello I am using this query which gives me the results shown in the picture:
SELECT "t_stamp", "Total_Parts" FROM myTable WHERE "MachineName" = 'Main01' AND "Quality" is not NULL AND t_stamp >= '2023-08-10 16:30:00' AND t_stamp <= '2023-08-14 00:30:00' ORDER BY 1 ASC
I wonder how can I get only the count for every hour... For example: I know I would have to sum the values from the Total_Parts column (in the red-box) but only for hour 17, and then the ones in the purple-box for the hour 18, and for the green-box for the hour 19.. Like the following table:
I was looking at this link, but still could not figured it out. Any help would be very much appreciate it. Thank you.