How to group timestamps by hour *without* skipping hours with no values?

Hey all!

Im new here (migrating my db from bubble) and learning the platform.

My issue: I have a bar chart that shows a group by hours of some data. I want to send data to that chart without missing any hour of the day even if it did not have any values to it.

Any recommendations on how to approach it?

My initial thout was to:

1. query all records of that user & group by hour of day + count

2. create an array variable that holds all hours of day such as [0, 1, 2, 3, ....]

   

3. Than to match the two lists using the time of day as key - and this is what im struggling with

Would appreciate any help!

Thanks

Omer