Hi there,
I'm charting multiseries data displayed in stacked columns with the following command:
stats dc(Process_Name) by
hostname,Company | xyseries
hostname,Company,dc(Process_Name)
This works fine, except for the fact that I now have over 5000 hosts (i.e. values for 'hostname') and I need a way to quickly display only the ones with the most number of processes (i.e. discrete values of 'Process_Name'). If I could make it work, something like 'top' or 'head' would be great:
stats dc(Process_Name) as processes by
hostname,Company|sort
hostname,-processes|head 50|xyseries
hostname,Company,processes
The sort command seems to provide unpredictable results though when it is preceded by a multi-value command (e.g. the B,C in 'stats(A) by B,C'). Can anyone offer me a way to view just the top 50 (or whatever) hosts when sorted by the number of processes?
Thanks for the help.
... View more