Include both time bounds in group by time(1h) in Influxdb

I am trying to implement group by time(1h) and it’s working fine. Suppose for 2:00 o’clock I used group by method then it starts taking interval from 1:00 to 1:59 and 3:00 it starts from 2:00 to 2:59. Now I want to implement a method that takes both bound of the time. 1:00 and 2:00 for 2:00 timestamp and 3:00 take 2:00 and 3:00.

Hello @Ravikant_Gautam,
Can you try grouping by the equivalent minutes instead?

Also, may I ask what your end goal is? Why do you want to group by 1hr + 1min? and then overlap the grouping the next hour? Am I missing something?

Actually, I am getting data at 15 mins interval
01:00:00
01:15:00
01:30:00
01:45:00
02:00:00
So, I want to use group by for one hour including 01:00:00 and 02:00:00 timestamp and save under the timestamp 01:00:00.