Splunk Search

How to calculate row sum which each column has different weight?

hakusama1024
New Member

Hi

I have a table as below.

severity S0 S1 S2 S3
event A 1 0 0 0
event B 0 2 0 0
event C 0 1 1 0

each column has different weight. for example S0 = 1,000,000, S1 = 10,000, S2 = 100, S3 = 1. i want to sort the event based on the weight multiply by the event number.
Please advise.

Tags (3)
0 Karma
1 Solution

HeinzWaescher
Motivator

try this:

| eval weight=(S0*1000000 + S1*10000 + S2*100 + S3*1)
| sort 0 - weight

View solution in original post

HeinzWaescher
Motivator

try this:

| eval weight=(S0*1000000 + S1*10000 + S2*100 + S3*1)
| sort 0 - weight

hakusama1024
New Member

thank you sir.

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...