I am working on a "haven't heard from you in a while" use case. I would like to identify measurements which haven't been pushed to influx in the normal expected elapsed time between measurements.
let's say I have some measurements like this: 10-Oct color=blue, value=1.8, measurement=mycolors 12-Oct color=blue, value=1.1, measurement=mycolors 14-Oct color=blue, value=1.0, measurement=mycolors //the normal elapsed time is 2 days between measurements for tag color=blue 10-Oct color=red, value=2.0, measurement=mycolors 17-Oct color=red, value=2.5, measurement=mycolors 24-Oct color=red, value=2.1, measurement=mycolors //the normal elapsed time is 7 days between measurements for tag color=red I want to identify the cases where I haven't recieved a measurement in the normal expected elapsed time grouped by a given tag. Something like this (which doesn't work): select value, color from mycolors where time < now() - elapsed(value) group by color -- 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/27adeeab-3d4d-40bf-bce0-cb88e3b3ed8e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
