Splunk Search

Funnel by Field

Timeago
Explorer

... | table Field Count | sort 0 Field

For example, we have






















Field Count
n1 1
n2 10
n3 100
n4 1000

How can I make funnel like this?






















Field Count
n1 1
n2 11
n3 111
n4 1111

Value of Funnel is equal to sum of previous value of Funnel and current value of Count.

Tags (1)
0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Append this:

... | streamstats sum(Count) as Count

View solution in original post

kristian_kolb
Ultra Champion

Or the built-in command accum specifically for this purpose;

... | accum count

http://docs.splunk.com/Documentation/Splunk/5.0.2/SearchReference/Accum

/K

martin_mueller
SplunkTrust
SplunkTrust

Append this:

... | streamstats sum(Count) as Count
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...