Splunk Cloud Platform

How to use stats sum and stats count by in Single command?

kalaiyarasi
Loves-to-Learn Lots

Hi,

I have below fields in which i need to display the count of each field value
|eval TotalApps=if(match('Type'="NTB"),"1","0")

|eval InProgress=if(Type= "NTB" AND isnull(date),"1","0")

|eval Submitted=if(Type= "NTB" AND isnotnull(date),"1","0")
|eval Apps_Submitted=if(match('Myinfo_Used',"1"),'REASON_CD',"0")
|stats count by Apps_Submitted

getting results as

COPS   1

CMS   2

FCO   3

but requirement is

|stats sum(TotalApps) as TotalApps sum(InProgress) as InProgress sum(Submitted) as  Submitted (along with the AppsSubmitted count of each field value)

Eg:

TotalApps    10

InProgress   5

Submitted   5

AppsSubmitted  5

COPS       1

CMS         2

FCO          3

Labels (1)
Tags (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Please share some sample events in a code block </> so we can see what you are dealing with.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

&#x1f342; Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...