topic How do you group field values based upon user, and then filter users that have only one type of value? in Getting Data In

How do you group field values based upon user, and then filter users that have only one type of value?

kellihall — Fri, 26 Feb 2016 15:24:38 GMT

Each user can have two values of type: movement and check-in. There are some users that only have movement and never check-in.
I've tried grouping these type values and then filtering those users that only have one value, but can't quite figure it out!

Re: How do you group field values based upon user, and then filter users that have only one type of value?

somesoni2 — Fri, 26 Feb 2016 18:30:28 GMT

Try something like this

index=dfw host=MC1 | stats values(type) as Action by id | where mvcount(Action)=1 AND Action="movement" | sort Action