After Eventstats two events are clubbed to a single row. how to ignore second event

[DataOrg]

Below column has two values after eventstats command. i want to ignore the second events "Passed" from the column "Value". i tried Mvexpand  to spilt but i totally dont want since i cant use dedup to remove duplicates

[johnhuang · Accepted solution]

You can use mvindex to replace itself with the first value

| eval Value=MVINDEX(Value, 0)