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
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
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
Thanks it got worked.