@mrovirab - If this helps kindly go ahead and click on "Accept as Solution" on the right answer so people in the future will get help from this. Thanks!! ... View more

``` Gather all the unique values of Product into a multi-value field called Product ``` | stats values(Product) as Product by ticket_number ``` Create a copy of the multi-value field without the "Other" product value ``` | eval _Products=mvfilter(Product!="Other") ``` Overwrite Product with the filtered version if it is not null ``` ``` _Products will be null if the only Product for the ticket is Other ``` | eval Product=coalesce(_Products,Product) ``` Count the occurrences of each Product (including Other) ``` | stats count by Product ... View more