作者:手机用户2502939177 | 来源:互联网 | 2023-02-01 23:18
如何仅按年,月,日和小时汇总记录?
1> Jeremy Hutch..:
在Application Insights Analytics中:
按小时:
requests
| summarize count() by bin(timestamp, 1h)
白天:
requests
| summarize count() by bin(timestamp, 1d)
按月计算
requests
| summarize count() by bin(datepart("Month", timestamp), 1)
到了一年
requests
| summarize count() by bin(datepart("Year", timestamp), 1)
只是想提一下,还有别名:startofday(timestamp),startofweek,startofmonth和startofyear.它应该更容易使用.