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!

Celebrating Fast Lane: 2025 Authorized Learning Partner of the Year

At .conf25, Splunk proudly recognized Fast Lane as the 2025 Authorized Learning Partner of the Year. This ...

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...