Dashboards & Visualizations

How to do a simple calculation based on two form values?

apnetmedic
Explorer

I've got two tokens in an input form, let's call them token1 and token2. They are each used to construct some searches, and that's all fine and good.

I'd also like to do a simple calculation based on these, like: someResult = token1 x token2 x someConstant, and display that in a single value panel.

I just can't figure out how to do that without an actual search involved. It's got to be easy... right?

Tags (2)
0 Karma

jlin
Splunk Employee
Splunk Employee

I believe the best way would be to use calculated fields - http://docs.splunk.com/Documentation/Splunk/6.2.0/Knowledge/definecalcfields

In props.conf, you could set up a calculated field such as:


[<stanza>]
EVAL-<field_name> = <eval statement>

which in your case:


[<your_stanza>]
EVAL-someResult = token1 * token2 * <someConstant>

0 Karma

somesoni2
Revered Legend

You can create dummy results using gentimes without hitting any actual index/sourcetype.

e.g.

|gentimes start=-1 |  eval someResult = $token1$ * $token2$ * someConstant | table someResult
0 Karma

apnetmedic
Explorer

Even easier is probably something like:
| stats count(_raw) | eval someResult = token1 * token2 * someConstant | table someResult

That spends minimal time on the search, which returns 0 events, then stats count() returns 1 row, and my eval then produces something.

EDIT: took out an initial empty search. @somesoni2 led me there with the | gentimes | idea. That works too, really anything that will generate one row of data to throw away.

0 Karma

Raghav2384
Motivator

Can be achieved using post processing searches.
Make the selections mentioned in the search template, please refer ui examples app.

Once you have the parent search, insert a separate chart panel to do some thing like table someResult.
someResult would be (token1*token2*constant). There might be other ways to do it.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...