How to create 15min interval using datetime & value fields in Quicksight

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

Shouldn’t this be addDateTime((extract(‘MI’, datetime) % 15), 'MI', datetime)

Literally, I have tried with ‘MI’ yesterday, I was testing something else and pasted the wrong formula with ‘HH’.

find the result below, it is still not working

Ah you need to subtract the remainder. Not add it.