Splunk Report- How to remove item from results?

[revanthammineni]

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

[SanjayReddy]

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.