I've got some Kwh meters that will output the numbers of pulses since the last update and the total number of pulses. I wanted to use the total number of pulses, the idea being that if Influx, Telegraf or the network was down, the difference can always be calculated.
To that end I created a continuous query like this: cq_splitheatpump CREATE CONTINUOUS QUERY cq_splitheatpump ON home BEGIN SELECT non_negative_derivative(max(value), 1m) AS value INTO home."1day".splitheatpump FROM telegraf.autogen.mqtt_consumer WHERE topic = '/wpmonitor/SplitEnery/Total' GROUP BY time(1m) END But this was a bit naive, when I mucked up my Telegraf config this afternoon resulting in a Telegraf that didn't run I saw that it would start logging the new data but it didn't calculate the difference between the total value at 22:00 and that at 17:48 when I crashed Telegraf. Is there a way to make essentially backfill the gaps in the data with continuous queries? I have the data, I can calculate it by hand and correct the data, but that wasn't the idea. Thanks! -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/14cc869d-036d-4dce-97bf-de5d1f667139%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
