We are trying to roll down data for every 2hrs using time_floor function. If I perform the roll down on datapoint that is at 10.07 AM it rolls down to nearest multiple of 2hrs which is 10 AM. How can I make it roll down to 9 AM ?
use case 9 AM to 11 AM data should be rolled down to 9AM, using time_floor it always rolls down to 10AM.
Any suggestions would be really appreciated !