Hi everybody,
Rather new to Influxdb here, and trying to create some visualizations on
top of it.
Got a bit stuck trying to create a query to get a specific count. I have a
custom service constantly pushing a measurement jobstatus with host, job,
and status. More or less every 5 mins Influx receives that metric for each
(host, job) pair. While I am able to create a table that shows for example
all the host/job pairs where status is -1 (but, very important, showing
only the last status received for each host/job) I'm not being able to
create a query that just counts them, so I can display it on a single stat
panel. Any hints?
I'm using this to display a table in Grafana with the list of host/service :
SELECT last("f_status") as "Current Status", "f_old_status" as "Previous
Status" FROM "autogen"."jobstatus" WHERE "t_status" = '-1' GROUP BY t_host,
t_job
Any help appreciated.
rgds.
--
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/a88d379d-ed65-4a03-a578-937fd9b04e52%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
