Archive
Highlighted

Unique number of users

Explorer

Hi , I am running a query to get count of unique users like
| stats dc(user)

How do I get list of those unique users?

Tags (1)
0 Karma
Highlighted

Re: Unique number of users

Motivator

Try this:

| stats values(user)

You can combine it with the distinct count like this

| stats values(user) as users dc(user) as usercount

Alternatively:

| stats count by user
0 Karma
Highlighted

Re: Unique number of users

Legend

Hi @rashi83,
Try this:

your_search
| dedup user
| sort user
| table user

Ciao.
Giuseppe

0 Karma