I'm looking to compare two groups of values from a data sample like this.
Group, User
Group1, User1
Group1, User2
Group2, User1
Group2, User3
My goal is to note how similar one group is to another. I know I can do a stats command of values(User) by Group to get a listing of each group with a field that has all the users included. I'd like to compare Group1 and Group2 to be able to say they have 75% similar values or something like that.
Not sure how to do it. My initial thought was to do something like appending the full contents of the Group I am trying to compare to every event and then performing a comparison between the User and that added field, but I don't know how to add that to every event. Doesn't seem like eventstats would work there.
... View more