Good afternoon
could someone help me with this query:
I have the following values
| users | Age |
user1 | 99
user2 | 99
How can I compare that if the user user1 of age 99 is equal to the user of age 99, then OK?
The field that has these users is called user and age has the values for each user
Any help is appreciated
Regards
maybe try something like this:
| makeresults count=1
| eval user="bob,rob,todd,jon,max,ben"
| makemv delim="," user
| mvexpand user
| eval age = random()%4
| stats values(user) as all_users_with_same_age by age
| eval OK = if(mvcount(all_users_with_same_age) > 1,"OK","NOT OK")
hope it helps
Can you further clarify? Are you comparing user1=user2 or age of user1 = age of user2? What does OK mean?