topic Re: Conditionnal stats aggregation in Splunk Search

How to make conditional stats aggregation query?

mxh7777 — Thu, 08 Dec 2022 19:37:05 GMT

Hi,

I'm looking for how to make conditional stats aggregation query according to a form input "With users" (value : Yes or No)

I got a list of events per User

When form input With users is equal "Yes", i'd like to present such a table

Query : | stats count as avgNb avg(DUR) as avgDuration by USR

An when form input With users is equal "No", i'd like to present this one

Query : | stats count as avgNb avg(DUR) as avgDuration

How can I build my query according to this form input condition?

Thanks

ITWhisperer — Thu, 08 Dec 2022 11:19:55 GMT

It looks like your queries are more like

| stats count as avgNb avg(DUR) as avgDuration by USR URI

and

| stats count as avgNb avg(DUR) as avgDuration by URI

Given that, you could set up the label and value of the input to be like this

Then modify the query like this

| stats count as avgNb avg(DUR) as avgDuration by $user$

mxh7777 — Thu, 08 Dec 2022 12:59:47 GMT

Thanks for answering.

I tried this just to see if it works but it doesn't work

| eval label="USR URI" | stats count as avgNb avg(DUR) as avgDuration by $label$

=> No results return

whereas this works

| stats count as avgNb avg(DUR) as avgDuration by USR URI

Something wrong in my eval instruction ?

Thanks

ITWhisperer — Thu, 08 Dec 2022 13:07:46 GMT

Yes, the label and value are from your form input (which you have referenced but not shown) not an eval

mxh7777 — Thu, 08 Dec 2022 13:44:18 GMT

It works perfectly !!

Thanks a lot