Tumbling Window (between every window start 1 hour gap and each window length is 1 hour)
from(bucket: "pcbulk") |> window(every: 1h, period: 1h) |> mean()
Hopping Window (between every window start 1 hour gap with each window duration 2 hours). So there is overlap.
from(bucket: "pcbulk") |> window(every: 1h, period: 2h) |> mean()
Now I trying to find out how to sliding window, where it is based on both time and when an event arrives. Sliding Window that I want to achieve is detailed in below links
Azure Stream Analytics: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions#sliding-window AWS Kinesis: https://docs.aws.amazon.com/kinesisanalytics/latest/dev/sliding-window-concepts.html
How to achieve similar functionality in Influx ?