I have about 100 different metrics_names and I'd like to be able to
I have about 100 hosts and they all have a metric racknumber and serialnumber.
The 100 hosts I don't care about but I want to plot every single metric where racknumber=1 and serialnumber=12345 and take a look at it.
I think I may have answered my own question
|mstats avg(value) as latestvalue span=15m WHERE metricname=* index=* racknumber=1 serialnumber=12345 by metricname
|where latestvalue > 10000
|timechart span=15m avg(latestvalue) by metric_name limit=0