Kusto汇总不同行的总数

Question

由于操作系统版本不同，以下数据表中相同构建、设备和层的计数被拆分为不同的行。请问我该如何总结总数，不包括平台操作系统？例如，我需要将构建的总计数总结为1388+1739+2070；19.50.20〃；，设备-"；谷歌"；，三级

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",
]

Answer 1

如果我理解正确，这可能会起作用：

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 sum(count) by build_ver, device, tier