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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...