topic Streamstats for multiple columns in Splunk Search

Streamstats for multiple columns

mbschriek — Tue, 29 Sep 2020 10:12:43 GMT

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?

Re: Streamstats for multiple columns

mbschriek — Thu, 14 Jul 2016 10:42:59 GMT

Solved it myself:

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

Re: Streamstats for multiple columns

woodcock — Sat, 16 Jul 2016 03:15:49 GMT

Be sure to click Accept on your answer.