So i have a adonis model where i store propertyValue and each entry has a timestamp (ISO 8601). There are several properties which is related via a propertyId.

So my objective is to aggregate data and get averages over a day for a particular...