azure - 如何在 Azure Application Insights 上进行独特的分析

Question

我当前使用 Application Insights Analytics 运行以下查询:

customEvents 
| where name == 'Event Name 1' 
| project ['Column One'] = customDimensions['CD1'], ['Column Two'] = customDimensions['CD2'], ['Column Three'] = customDimensions['CD3']

上面的查询返回一些如下结果:

Column One | Column Two | Column Three
    A      |     2      |      D
    B      |     3      |      E
    C      |     2      |      F

如何让查询仅返回第二列上的不同值？基本上我希望我的结果是:

Column One | Column Two | Column Three
    A      |     2      |      D
    B      |     3      |      E

任何帮助将不胜感激!

Answer 1

你可以这样做:

customEvents 
| where name == 'Event Name 1' 
| project ['Column One'] = tostring(customDimensions['CD1']),
          ['Column Two'] = tostring(customDimensions['CD2']),
          ['Column Three'] = tostring(customDimensions['CD3'])
| summarize any(['Column One']), any(['Column Three']) by ['Column Two']

这将选取“A, C”对中的第一个 - 不一定是 A。如果您想排除“C”，那么您需要使用其他汇总聚合器，例如 makelist/makeset。