I have environment measure points. I switched recently from a custom solution to influxdb. I was wondering how I can calculate the avg. on the fly and save them in another data point.
Every minute I get a new data point. This resolution is only required if the data is less than one week old. Which is why, in parallel to the exact resolution, I would like to determine an hourly and a daily one, which I would like to keep longer. The hourly resolution for one month and the daily resolution should never be deleted automatically.
What would be the approach to produce something like this with influxdb?
