You'll need to use a CQ to store the elapsed times, then use that calculated value as the comparator in another query.
On Mon, Nov 7, 2016 at 7:03 AM, <goog...@gmail.com> wrote: > 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvNd%2BVPfV-mm1erP2aJfERLkhsaN2VxcpWz0z94ThD1dDw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
