topic Re: Metrics in chart in Splunk Search

Metrics in chart

sizemorejm — Wed, 12 Jul 2023 12:58:00 GMT

I am trying to use a radial gauge graph in order to show a % using avg(cpu_metric.Idle). However, I want the "reverse" value of the cpu_metric.Idle. So what I am attempting to do is

| mstats .................. hostname.......... | chart count(eval( 100 - avg(cpu_metric.Idle)) as name

Basically I am trying to show " 100 - avg(cpu_metric.Idle)" on a gauge and the only way for me to get the new value is doing " | chart avg(cpu_metric.Idle) as name | eval new = 100 - name " but I cant put the eval value onto a chart.

Re: Metrics in chart

yuanliu — Thu, 13 Jul 2023 10:57:39 GMT

Now sure why you cannot put the eval value onto a chart, but chart may not be necessary. There are multiple ways to do this. If you want to use chart command after mstats, do this

| mstats avg(cpu_metric.Idle) as cpu_metric.Idle where .................. hostname.......... | chart values(eval( 100 - cpu_metric.Idle)) as name

Alternatively, and perhaps slightly more efficiently, you can do simple eval

| mstats avg(cpu_metric.Idle) as name where .................. hostname.......... | eval name = 100 - name

Re: Metrics in chart

sizemorejm — Thu, 13 Jul 2023 13:03:27 GMT

For both set, I get an error saying "No results found. Try expanding the time range.

Re: Metrics in chart

yuanliu — Thu, 13 Jul 2023 22:35:33 GMT

Then it's a question about your data source. Are you sure metric cpu_metric.Idle exists? Do you know which index (indices) is(are) metrics index/indices? Forget that remainder. What does this give you?

| mstats avg(cpu_metric.Idle) as name where index=my_metrics_index

If this also has no result, examine your data source deeper.

| mstats avg(cpu_metric.Idle) as name where index=my_metrics_index | foreach * [eval metrics = mvappend(metrics, "<<FIELD>>")] | table metrics

Do you have any metrics index at all? In fact, why did you show an invalid mstats command in the original description? I'm just trying to follow your original logic.