Splunk Search

Streamstats for multiple columns

mbschriek
Explorer

The following table is representing positions in uPos for different columns. Each number in a c_ column is representing the number of positions are taken, starting at the position which the number is positioned.

For example:
The item in column c_A - 7 is representing reserved cells at uPos 7, 8, and 9.
The item in column c_F - 2 is representing reserved cells at uPos 2, 3, 4, and 5.

Goal:
I would like to fill all the reserved cells with a number to represent a nice bar chart.

Does anyone has an idea to solve this?

alt text

Tags (1)
0 Karma
1 Solution

mbschriek
Explorer

Solved it myself:

 | foreach c* [eval <<FIELD>>='<<FIELD>>'+uPos-1] | makecontinuous uPos | filldown c* | foreach c* [eval <<FIELD>>=if(('<<FIELD>>'-uPos)>=0,"1","0")]

View solution in original post

0 Karma

mbschriek
Explorer

Solved it myself:

 | foreach c* [eval <<FIELD>>='<<FIELD>>'+uPos-1] | makecontinuous uPos | filldown c* | foreach c* [eval <<FIELD>>=if(('<<FIELD>>'-uPos)>=0,"1","0")]
0 Karma

woodcock
Esteemed Legend

Be sure to click Accept on your answer.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...