Hey,
I'm trying to show the errors of an application in the past hour. This is
stored in InfluxDB as an incremental counter, so say that at the start of the
hour the value is 5, at the end it's 12, and I want to show 7.
This is easily done with a query like this:
SELECT MAX("Total_#errors") - MIN("Total_#errors") FROM "process_x" WHERE
"time" > now() - 1h;
However, this counter sometime bugs out, injecting a 0 value into the database.
This cripples the query, as it'll show the max errors instead of the delta.
I've tried using bottom 2, or max(bottom 2), but nested expressions aren't
supported. Does anyone have an idea on how to tackle this?
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/71c6edf6-d96a-4faf-9c72-9f542ad9da85%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
