sum by hrs

[Viv1892]

Hi,

I have a query which gives me total qty scanned and timestamp. I would like to get total qty for each hour. I’m writing this in DBeaver which is my first time using this platform. Can anyone please help me how to sum qty hourly? I have attached the img for reference. This data goes for more than 3 months.

Thanks!
sum by hours.xlsx

[LonwoLonwo]

Hello @Viv1892

Maybe some of the Panels will be helpful in your case: https://github.com/dbeaver/dbeaver/wiki/Panels
Grouping or Calc.