azure-log-analytics - 如何在 Kusto 中按日期按列获取 sum()

Question

我想在 LogAnalytics 中按日期的某些列生成一个指标为 sum by count 的报告。

到目前为止我可以使用-

Perf
| summarize sum(CounterValue) by TimeGenerated, Computer

在屏幕截图中给出了以下结果。但我想要每天的格式。像-

Date,Computer,sum_Count
01-17-2020,ABC,100
01-16-2020,ABC,132
01-17-2020,XYZ,700
01-16-2020,XYZ,800

Answer 1

尝试使用startofday():

Perf
| summarize sum(CounterValue) by startofday(TimeGenerated), Computer

或bin():

Perf
| summarize sum(CounterValue) by bin(TimeGenerated, 1d), Computer