Splunk Enterprise

How to find single value based on result in a table?

Julia1231
Communicator

Hi everyone,

Please help me with this problem.

After doing some search by Splunk, I have results in a table below:

Id Average
1231 130
1234 540
1568 220
7564 116
7894 273

 

No I need to calculate some values that based on the average in the table.

For ex: result1= average of id 1231 / average of id 7894

result 2 = average of 1568 / average of 1234

How can I do it please?

Thanks in advanced!

Labels (1)
Tags (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try using chart instead of stats

| eval row=1
| chart avg(Average) as Average by row Id

Depending on the search you used to create your table, you may be able to do this a different way

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...