Splunk Search

Why doesn't the stramstats work when I group by certain field?

buttsurfer
Path Finder

The search below doesn't work when i add department in the group by fields in the streamstats commands. It works with any other field but this one. Can someone please give some insight?

 

 

 

index=...
| lookup lookup cn as user OUTPUT department
| reverse
| dedup department application feature time
| streamstats current=f window=1 values(currTotalCount) as prev_count by application feature department
| table department application user display time feature currTotalCount prev_count

 

 

 

The prev_count field is empty when i add the department in the group by fields (streamstats command), otherwise it shows the correct result.

Labels (3)
0 Karma
1 Solution

buttsurfer
Path Finder

Fixed it by adding global=false

View solution in original post

0 Karma

buttsurfer
Path Finder

Fixed it by adding global=false

0 Karma
Get Updates on the Splunk Community!

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 ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...