Dashboards & Visualizations

Grouping Column Results after Stats Output

cchange
Path Finder

I'm trying to combine count of Ipad and iPhone to a single result. I tried appendcols function but no luck. Can anyone please let me know how to combine this two fields and sum of them as single result.

Current Result
System Count
Ipad 4567
iPhone 5678
Windows 7890

Looking Result
IOS 10245
Windows 7890

Thanks

Tags (1)
0 Karma
1 Solution

somesoni2
Revered Legend

Try like this

your current search giving your Current Result with fields System and Count | eval System=if(System="Ipad" OR System="iPhone","IOS", System) | stats sum(Count) as Count by System

View solution in original post

somesoni2
Revered Legend

Try like this

your current search giving your Current Result with fields System and Count | eval System=if(System="Ipad" OR System="iPhone","IOS", System) | stats sum(Count) as Count by System

cchange
Path Finder

Thanks it got worked.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...