I think @gcusello 's answer is the best scalable approach. If it's something quick and small, you could do something like this to keep it all in the SPL without needing a lookup: index=brandprotection name IN (ali, ahmad, elias, moayad)
| stats count BY name
| append
[| makeresults
| eval name="ali, ahmad, elias, moayad"
| eval name=split(name, ", ")
| mvexpand name
| eval count=0
| fields name count]
| stats sum(count) AS count BY name
... View more