CODEWITHSUNDEEP
azure-data-explorerkql
Omkar Neogi
Omkar Neogi

Reputation: 745

Kusto Query Language: Sum a column

How do you perform the equivalent of an SQL sum SELECT SUM(column_name) FROM table_name in Kusto Query Language for Azure Data Explorer?

Upvotes: 2

Views: 6712

Answers (1)

Omkar Neogi
Omkar Neogi

Reputation: 745

app("your-app").tableName 
| summarize sum(columnToSum)

You don't need to have a "by" statement in your summarize, but you can add it for performing a group by, for example,

app("your-app").tableName
| summarize sum(columnToSum) by columnToGroupBy

Upvotes: 4

Related Questions