如何在Kusto中按Build、Device、Tier汇总计数（忽略OS版本差异）

要实现忽略OS版本，按build_ver、device、Tier分组汇总count的总和，你可以使用Kusto查询语言的summarize运算符，配合sum()聚合函数完成。

完整查询代码 #

datatable (build_ver: string, device: string, Tier: long, count: long, os: string) 
[
    "19.50.20","Google",long(3),long(1388),"10.1",
    "19.50.20","Google",long(3),long(1739),"10.2",
    "19.50.20","Google",long(3),long(2070),"10.3",
    "19.50.20","Windows",long(2),long(1486),"11",
    "19.50.20","Windows",long(2),long(1476),"11.2",
]
| summarize total_count = sum(count) by build_ver, device, Tier

代码说明 #

• summarize：用于对数据执行分组聚合操作
• sum(count)：计算每组内count字段的总和，并将结果命名为total_count
• by build_ver, device, Tier：指定分组依据的字段，三个字段完全匹配的行会被归为同一组

查询结果示例 #

内容的提问来源于stack exchange，提问作者Milo_Dev