I have two sources of data. One that has an Account Name, License Key, and Account Revenue. The other has License Key and an Item_Count field.
Current it shows like this
LicenseKey Item_Count
200IGN3 4
200IGN3 10
342mD3D 8
342mD3D 6
I would like to remove the duplicate keys and add up there item counts.
How would this be done?
Thanks in advance.
Try like this
your current search showing fields LicenseKey Item_Count
| stats sum(Item_Count) as Item_Count by LicenseKey