Hi QS community,
I am struggling to create 15min interval using datetime & value fields.
Basically I am trying to calculate/display number of people count at that given time within the 15min interval based on the value.
Calculated field: datetime (15min Interval) - addDateTime((extract(‘MI’, datetime) % 15), ‘HH’, datetime)
getting below result
|datetime (15min Interval)|value|
|2023-02-28 11:00:10|268|
|2023-02-28 12:00:04|289|
|2023-02-28 13:00:02|304|
|2023-02-28 14:00:01|319|
|2023-02-28 15:00:00|328|
|2023-02-28 16:00:00|333|
|2023-02-28 18:00:01|339|
|2023-02-28 19:13:53|340|
|2023-02-28 20:13:55|680|
|2023-02-28 22:13:52|344|
|2023-02-28 23:13:54|690|
Something like this I am trying to achieve.
Your help will be appreciated