How do you get a stacked bar chart that lists only the top X users?

[richardphung]

I have data that is structured as such:

Using the following:

index="myindex"  |  chart count over username by result

I get a nice stacked bar chart.. and a table as such:
User1, success, count
User1, failure, count
User2, success, count
User3, failure, count

How can I only chart the top X users?

|top 20 username

Gets me the top values.. but limit=20 doesn't seem to work with chart

[richardphung · Accepted solution]

index="myindex"
    [search index="myindex"  
    | top  10 username 
    | fields username
    | sort -count]
| chart count BY username result

*Notice, the no-pipe into the 2nd search.