I'm trying to print a line chart with three values:
I'm trying this:
stats mean(percentIdle) AS mean, stdev(percentIdle) AS stdev | eval down= mean-stdev | eval up= mean+stdev | timechart first(down) as "min" first(up) as "max" first(percentIdle) as "percentIdle"
And similar variations but nothing works.
Does anyone knows how to do this?
that actually didn't give me exactly what i needed, because that prints the mean, the stdev and the eval result, but I fixed it with this:
timechart eval(mean(percentIdle) + stdev(percentIdle)) AS up, eval(mean(percentIdle) - stdev(percentIdle)) AS down, first(percentIdle) as percentIdle
This prints the metric itself, the mean+stdev and the mean-stdev 🙂
Thank you for the reply!
Please can you try the following:
| timechart mean(percentIdle) AS mean, stdev(percentIdle) AS stdev
| eval up = mean+stdev, down=mean-stdev
Let me know if you're still having problems.