Hi Everyone,
If I have 2 metrics
one is cpu.1
2nd one is cpu.2
And i am using the below Query to get the metric percentages
| mstats max(_value) avg(_value) min(_value) prestats=true WHERE metric_name="cpu.1" AND "index"="myindex" AND [| inputlookup metrics.csv] BY host span=30min
| stats Max(_value) AS Max Avg(_value) AS Avg Min(_value) AS Min BY host
| eval Status=if(Avg<75,"good",if(Avg>=75 AND Avg>=90,"critical","Warning"))
Now my question is
I need both toatlcpu=(cpu.1+cpu.2) in one query, and it should shows max(totalcpu), avg(totalcpu), min(totalcpu)
Can guide me please.ThankQ