To get TopXRows for each ActivityId from Traces Table

[suniltakhtani]

Hi Team,

I have "Traces" table in kusto, i want to write a query to fetch TopXRows for each ActivityId.

For Ex: I have 3 ActivityId and TopXRows=5

So I want to fetch 15 records from Traces table order by Timestamp, with 5 records for each ActivityId.

Is this possible in kusto?

@

[#2]

Check out https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/topnestedoperator or https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/mv-applyoperator