How to query for "all but one" in graphite/grafana

graphite grafana
sprugman picture sprugman · Dec 11, 2015 · Viewed 20.9k times · Source

I'm playing with grafana and I want to create a panel where I compare data from one app server against the average of all the others except that one. Something like:

apps.machine1.someMetric
averageSeries(apps.*.not(machine1).someMetric)

Can that be done? How?

Answer

Scott picture Scott · May 6, 2016

Sounds like you want to filter a seriesList, you an do that inclusively using the 'grep' function or exclusively using the 'exclude' function

exclude(apps.machine*.someMetric,"machine1")

and pass that into averageSeries

averageSeries(exclude(apps.machine*.someMetric,"machine1"))

You can read more about those functions here: http://graphite.readthedocs.io/en/latest/functions.html#graphite.render.functions.exclude

Related questions

nginx 403 Forbidden error

I'm trying to set up graphite to work with grafana in docker based on this project : https://github.com/kamon-io/docker-grafana-graphite and when I run my dockerfile I get 403 Forbidden error for nginx. my configurations for nginx are almost the …

Read More
How to change the x axis in Graphite/Grafana (to graph by day)?

I would like to have a bar graph in graphite/grafana that has a single bar per day, over the week. Ideally we would have the days of the week (Monday,Tuesday...etc) on the x axis labels, and then …

Read More
Sum multiple metrics without summing over a wildcard?

I have the following metrics: folsomite.<host>.cache.hit1 folsomite.<host>.cache.hit2 folsomite.<host>.cache.miss1 folsomite.<host>.cache.miss2 folsomite.<host>.cache.miss3 (The caching library I'm using …

Read More