Kusto :汇总组并将其显示为 csv

Question

在下面的查询中，我想显示该用户的电子邮件ID和唯一用户ID。

customEvents
//| where customDimensions.UserId == 'Error'
| where  timestamp > ago(2d)
| summarize values = dcount(tostring(customDimensions.UserId)) by tostring(customDimensions.email)

数据：

UserId email
1      [e-mail]
Error  [e-mail]
2      [e-mail]
3      [e-mail]
Error  [e-mail]

预期输出：

[e-mail].   1, Error
[e-mail]      2
[e-mail] 3, Error 

Answer 1

你可以试试这个：

datatable(UserId:string, Email:string)
[
'1',     '[e-mail]',
'Error', '[e-mail]',
'2',     '[e-mail]',
'3',     '[e-mail]',
'Error', '[e-mail]',
]
| summarize UserIds = strcat_array(make_set(UserId), ", ") by Email