如何合并两个Application Insights自定义事件Kusto查询并计算平均百分比

开发者阿泽

2026-8-1

合并Kusto查询并计算平均百分比

可以通过两种方式合并查询，最终返回两个百分比的平均值：

方法一：单次扫描数据（更高效）

直接在一个查询中处理两种事件类型，避免重复扫描数据：

customEvents
| where name in ("JobsStarted", "JobsCompleted")
| project 
    timestamp,
    Id = tostring(customDimensions["Id"]),
    Frequency = toint(customDimensions["Frequency"]),
    IsValid = case(
        name == "JobsStarted", toint(customDimensions["JobsStarted"]) >= 1,
        name == "JobsCompleted", toint(customDimensions["JobsCompleted"]) >= 1,
        false
    )
| summarize 
    Percentage = (toreal(countif(IsValid)) / sum(Frequency)) * 100
    by name
| summarize AveragePercentage = avg(Percentage)

逻辑说明：

第一步过滤出目标事件类型
用case函数统一判断两种事件的有效条件，生成IsValid标记字段
按事件名称分组计算各自的百分比
最后对两个百分比求平均值，得到单一结果

方法二：复用原有查询逻辑（更直观）

通过临时变量保存两个查询的结果，再合并计算平均值：

let started_percent = customEvents
| where name == "JobsStarted"
| project 
    Id = tostring(customDimensions["Id"]),
    Frequency = toint(customDimensions["Frequency"]),
    JobsStarted = toint(customDimensions["JobsStarted"])
| summarize Percentage = (toreal(countif(JobsStarted >= 1)) / sum(Frequency)) * 100;
let completed_percent = customEvents
| where name == "JobsCompleted"
| project 
    Id = tostring(customDimensions["Id"]),
    Frequency = toint(customDimensions["Frequency"]),
    JobsCompleted= toint(customDimensions["JobsCompleted"])
| summarize Percentage = (toreal(countif(JobsCompleted >= 1)) / sum(Frequency)) * 100;
union started_percent, completed_percent
| summarize AveragePercentage = avg(Percentage)