Splunk Search

How to increment counter field with a by clause

e_sherlock
Explorer

Given events

Group MultiValue

A 7,2,9

B 8,1

I'm using makemv to pivot the results to below, but I also want a new Index/Counter field which counts (or shows the index value) and resets when it sees a new group. The accum command doesn't support a "by [field list]" so curious how to do this?

Group Value **Index/Counter**


A 7 1

A 2 2

A 9 3

B 8 1

B 1 2

Tags (3)
1 Solution

e_sherlock
Explorer

Got it working like this:

| streamstats count as index by Group

View solution in original post

e_sherlock
Explorer

Got it working like this:

| streamstats count as index by Group

sloshburch
Splunk Employee
Splunk Employee

Or just | stats count as index by Group should work I assume.

Get Updates on the Splunk Community!

There's No Place Like Chrome and the Splunk Platform

Watch On DemandMalware. Risky Extensions. Data Exfiltration. End-users are increasingly reliant on browsers to ...

The Great Resilience Quest: 5th Leaderboard Update

The fifth leaderboard update for The Great Resilience Quest is out >> 🏆 Check out the ...

Devesh Logendran, Splunk, and the Singapore Cyber Conquest

At this year’s Splunk University, I had the privilege of chatting with Devesh Logendran, one of the winners in ...