CODEWITHSUNDEEP
multiple-columnssettingskqlgroup
manymanymore
manymanymore

Reputation: 3128

Is it possible to group rows programmatically in KQL?

Is it possible to group rows programmatically in KQL?

I know that I can run a query in KQL. And after that go to the right hand Columns settings, drag a column name to the Row Groups and group my rows this way.

Is there a way to do the same operation programmatically while writing a query? I searched for it in documentation and found nothing. Does it mean it is possible to group rows in KQL only manually?

Upvotes: 1

Views: 436

Answers (1)

decius
decius

Reputation: 1445

Have you already tried summarize?

EDIT 1 - After clearification:

traces
| project timestamp, operation_Id
| summarize entries = make_list(pack_all()) by operation_Id

Upvotes: 1

Related Questions