Splunk Search

## Chart with multiple Row Fields that Share Values Over One Column Field

Engager

Hello,
I was wondering if you can have a chart that compares the average of one field depending on the value of several other fields. I want to compare the average runtime of a query and compare the time depending on how many certain conditions are set. So for example I want to see the difference of having 1 integer condition compared to 1 varchar condition as a side by side bar chart. The two charts I have that show the results are below:

| chart avg(runtime) as "Average Run Time(ms)" by Total.Count.Integer.Conditons

| chart avg(runtime) as "Average Run Time(ms)" by Total.Count.Varchar.Conditons

So the above two charts would ideally be one grouped by the number of conditions.

Thanks!

Tags (2)
1 Solution
Revered Legend

Give this a try

your current search before the chart command which has fields runtime  Total.Count.Integer.Conditons Total.Count.Varchar.Conditons
| untable runtime condition TotalCount
| eval IntRuntime=if(condition="Total.Count.Integer.Conditons",runtime, null())
| eval VarRuntime=if(condition="Total.Count.Varchar.Conditons",runtime, null())
| stats avg(IntRuntime) as "Average Run Time(ms) - Integer Condition"  avg(VarRuntime) as "Average Run Time(ms) - Varchar Condition" by TotalCount
Revered Legend

Give this a try

your current search before the chart command which has fields runtime  Total.Count.Integer.Conditons Total.Count.Varchar.Conditons
| untable runtime condition TotalCount
| eval IntRuntime=if(condition="Total.Count.Integer.Conditons",runtime, null())
| eval VarRuntime=if(condition="Total.Count.Varchar.Conditons",runtime, null())
| stats avg(IntRuntime) as "Average Run Time(ms) - Integer Condition"  avg(VarRuntime) as "Average Run Time(ms) - Varchar Condition" by TotalCount
Engager

Thank you. This was able to work!

Get Updates on the Splunk Community!

#### .conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

#### Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

#### Troubleshooting the OpenTelemetry Collector

In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...