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!
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
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
Thank you. This was able to work!