Hi Splunkers,
I have results in the following way.
Country Count
Japan 50
USA. 70
China. 60
India. 50
Tokyo. 5
Goal:
I want to add the count of Tokyo to Japan (55) and take off Tokyo from the results. Could anyone suggest me with a logic. TIA
Hi @revanthammineni
Just add following line in at the of the query or before stats/chart/ that you are using in query
| eval Country=if(Country="Tokyo","Japan",Country)
----
Regards,
Sanjay Reddy
----
If this reply helps you, Karma would be appreciated.
If your problem is resolved, then please click the "Accept as Solution" button to help future readers.