How do I limit the following search of the assetIds with the 10 highest calls?

[moizmmz]

Here's my query: 

index=dcg_prod handler=CanIplay sc=200|chart count as "calls" by assetId

I want to limit this query to the assetId s with the highest calls, i want just the highest 10 (top10)

I've used the top command, but it doesn't work. Pls help!!

[HiroshiSatoh · Accepted solution]

How's this?

 index=dcg_prod handler=CanIplay sc=200
       [search index=dcg_prod handler=CanIplay sc=200|top assetId|table assetId]
|chart count as "calls" by assetId

[moizmmz]

Worked like a charm 🙂 Thank you!!