我正在尝试检查我的customDimensions
对象是否具有属性,然后仅对将属性设置为某些值的查询进行计数。它计算的是SupportedLanguage
对象中没有customDimensions
属性的查询。
这是我当前的查询:
customEvents
| where timestamp > ago(7d)
| summarize COUNT=count(customDimensions.SupportedLanguage) by lang=tostring(customDimensions.SupportedLanguage)
| render piechart
我尝试执行以下操作,但没有成功:
customEvents
| where timestamp > ago(7d)
| where customDimensions.SupportedLanguage
| summarize COUNT=count(customDimensions.SupportedLanguage) by lang=tostring(customDimensions.SupportedLanguage)
| render piechart
最佳答案
为此,您可以利用isnotempty()函数:
customEvents
| where timestamp > ago(7d)
| where isnotempty(customDimensions.SupportedLanguage)