This will be a little complicated, but doable with a series of Gauge Query nodes. The Gauge Query allows you to query specific data from the past.
In the above screenshot, I’m querying data that was reported exactly 24 hours ago. The input supports negative times, which represent the past relative to now.
So to get the last three values reported at the same time of day as now, you’d use three gauge query nodes with the
Range End set to:
86400000 is 24 hours in milliseconds. So that’s
86400000 * 1,
86400000 * 2,
86400000 * 3, etc.
You can put this in a Loop Node to make changing the number of days and aggregating the results pretty easy.
Play with this concept and see if that works for you. I’d be happy to create an example workflow if you’re having difficulty implementing this approach.