azure - 在应用洞察分析中使用除法运算符

Question

我有以下应用见解查询:

let someResult=
customEvents | where name in ('SomeAction')
| parse customDimensions.someId with someId 
| parse customDimensions.sometaskId with someTaskId
| parse user_AuthenticatedId with user
| summarize max(timestamp) by user, someId , someTaskId
| join (
customEvents | where name in ('someAction')
| parse customDimensions.action with someAction
| parse customDimensions.someId with someId
| project someAction,someId
) on someId
| join (
customEvents
| where name in ('someResult')
| parse customDimensions.someId with someId 
| parse customDimensions.someIdsWithSomething with sometaskIds
| parse array_length(split(customDimensions.someIdsWithSomething ,',')) with someTaskCount
| distinct someId , sometaskIds,someTaskCount
| where sometaskIds<> ''
) on someId 
| summarize sumif(todouble(someTaskCount),someAction=="accept")/sum(todouble(someTaskCount));

我如何将 someResult 除以此处的某个内容。例如，我希望最终结果为 someResult/10 。谢谢您的帮助。

Answer 1

试试这个:

let someResult=
customEvents | where name in ('SomeAction')
| parse customDimensions.someId with someId 
| parse customDimensions.sometaskId with someTaskId
| parse user_AuthenticatedId with user
| summarize max(timestamp) by user, someId , someTaskId
| join (
customEvents | where name in ('someAction')
| parse customDimensions.action with someAction
| parse customDimensions.someId with someId
| project someAction,someId
) on someId
| join (
customEvents
| where name in ('someResult')
| parse customDimensions.someId with someId 
| parse customDimensions.someIdsWithSomething with sometaskIds
| parse array_length(split(customDimensions.someIdsWithSomething ,',')) with someTaskCount
| distinct someId , sometaskIds,someTaskCount
| where sometaskIds<> ''
) on someId 
| summarize summarized = sumif(todouble(someTaskCount),someAction=="accept")/sum(todouble(someTaskCount));
someResult 
| project summarized / 10

我无法测试它，因为我没有这些自定义尺寸，但它基于此工作/测试示例:

let someResult = requests
| summarize summarized = count();
someResult 
| project summarized / 10