Hi sp1711,
The obvious search is something like:
My_search | timechart values(client) AS client count by user limit=5
but this shows the top 5 globally, not the top 5 per day.
The problem with "per-day" is that every day could have 5 completely different top user and thus for a month, you may need 150 series.
If you really want to calculate per day, it's something more like:
My_search
| bin span=1d _time
| stats count by _time client user
| sort - _time count
| dedup 5 _time
this will give you, per-day, the top 5 client, user ,count groups.
Add this to graph / chart it:
| timechart span=1d values(client) AS client sum(count) by user limit=1000
Hope this helps ...
cheers, MuS
... View more