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!

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...

span_metrics: The OpenTelemetry-Idiomatic Way to See Inside Your Services

You open a trace in Splunk Observability Cloud and everything looks fine. One root span, order-pipeline, with ...