Daily average sampling window

Hi everyone,

Imagine a scenario where I have cpu utilisation data (%) every 1 second for multiple servers.

Is there a way to get mean cpu utilisation every hour for a day, for the last month? I would expect to get 24 points back, regardless of how big the window is (it could be 1 month or more).