Hi,
I am trying to get two cols from the same table onto a line graph. Each col is an independent value, so the graph should show two lines; I do not want to consolidate the two col together.
This is the Search SPL I am using to pull data:
------graph 1-------
mstats avg(_value) prestats=true WHERE metric_name="cpu.system" AND "index"="em_metrics" AND "host"="ABC" AND `sai_metrics_indexes` span=10s timechart avg(_value) AS Avg span=10s fields - _span*
------graph 2-------
mstats avg(_value) prestats=true WHERE metric_name="memory.used" AND "index"="em_metrics" AND "host"="ABC" AND `sai_metrics_indexes` span=10s timechart avg(_value) AS Avg span=10s fields - _span*
As you can see, almost everything is the same besides the metric_name. I am trying to get both metric_name data's onto one graph.
I tried to combine both metric_name into one by adding another AND statement, but it won't work.
Thanks in Advance!
... View more