Hi all, just after some advice / direction:
I have a flow meter reporting state to losant every 15 minutes. I am trying to compare each new reading with a running average of the same sensor data in the past X days which occured at the same time of day. Just wondering the best way to go about this in a workflow.
An example would be:
- a flow of say 20 liters is reported at 12:01 pm 24th November.
- I then want to retrieve the flow that was reported on the same device with the same hour/minute timestamp (12:01) for the past 10 days, average that result and compare it to the new reported flow.
Going around in circles on how to retrieve the historical info by hour:minute and average it… Any help much appreciated.