Hi,
I am using InfluxDB to store power consumption data. The Z wave module reports data every few seconds and I am using “Utility Meter” to aggregate data hourly, daily, weekly etc.
I would like to delete the raw data reported by the Utility Meter that is older than a month and keep only the value generated by the Utility Meter… is this possible?
I was going to suggest, if you don’t need the raw values and they are coming from the zwave entity, then you could just exclude them from influxdb entirely. But, since you’re storing them presumably you do want them for sub-hour data.
Otherwise, I think you would want to do something with multiple retention policies and a continuous query. Make the 30-day policy the default and with a CQ write the data you want to save to the no-retention policy. Or something like that.
Or, I suppose you could DELETE series. You would need to do that on your own, via some sort of command line script and an automation, or outside of HA.
The Influx python API that HA is using has the ability to set a retention policy when writing data points, but the HA integration does not have the ability to use it. Theoretically you could write the raw values with a non-default retention policy, while the utility meter values are written to the policy with infinite retention.
hi freshcoast, thanks for following up. The below diagram shows were I am using the RAW data (left graphs), the other graphs are being generated by the Utility Meter config.
I will out the DELETE suggestion, I dont mind if I have to do it manually every month or so, but also think I can do it from Node-Red … will keep you posted.