All Apps and Add-ons

search with 2 variables inside search

dirkbaumann
Explorer

Hi, could somebody please tell me how i can put 2 Variables inside one Query
I have Written the following



pages

page6
(page="page6")

+OR+
$value$
( $value$ )

Last 15 minutes


<![CDATA[index=page_Index source=page_test $pages$ | chart sum(count) As Result by Success]]>


zero
zero
pie


<![CDATA[
index=page_Index source=page_test $pages$| eval var=if($click1.searchTerms$, count, 0)
| stats sum(var) AS Suc, sum(count) As totalSuc by browser |
eval percentage=round( Suc*100/ totalSuc,2) |
fields - Variable , totalSuc | chart max(percentage) AS % by browser
]]>


column


<![CDATA[
index=page_Index source=page_test $pages$ $click2.searchTerms$|
eval var=if($click1.searchTerms$, count, 0) |
stats sum(var) AS Suc, sum(count) As totalSuc by browserMajorVersion|
eval percentage=round( Suc*100/ totalSuc,2) |
fields - launchSuc , totalSuc | chart max(percentage) AS % by browserMajorVersion
]]>












Could somebody please tell me how to pick 2 variables into one search at a specific place i tried to put it with click1.searchTerms and click2.searchTerms into the system but thats not working with click.searchTerms it's working but at the last query i could not have 2 variables inside

1 Solution

sideview
SplunkTrust
SplunkTrust

There is no valid key in your view called $click1.searchTerms$. I think you mean $click.searchTerms$, which is an extended key added to the JSChart's output by Sideview Utils.

There is a good docs page inside Sideview Utils that gives a broad overview of all the $foo$ tokens that are available with all relevant Sideview and Splunk modules.

Also, you can use the Sideview Editor in "Runtime Debug" mode to take a look at exactly what keys are at exactly what point in exactly what view, at runtime. Which is an overwhelming bit of power, but can be very useful....

By the way you can change the "click" part of that by setting "drilldownPrefix" param on JSChart. In a Sideview module you would always set a "name" param to change that, but the Splunk modules are a little inconsistent as to how you specify the name of the $foo$ token from module to module.

View solution in original post

sideview
SplunkTrust
SplunkTrust

There is no valid key in your view called $click1.searchTerms$. I think you mean $click.searchTerms$, which is an extended key added to the JSChart's output by Sideview Utils.

There is a good docs page inside Sideview Utils that gives a broad overview of all the $foo$ tokens that are available with all relevant Sideview and Splunk modules.

Also, you can use the Sideview Editor in "Runtime Debug" mode to take a look at exactly what keys are at exactly what point in exactly what view, at runtime. Which is an overwhelming bit of power, but can be very useful....

By the way you can change the "click" part of that by setting "drilldownPrefix" param on JSChart. In a Sideview module you would always set a "name" param to change that, but the Splunk modules are a little inconsistent as to how you specify the name of the $foo$ token from module to module.

Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...