- Welcome part. Just check the dashboard and the missing bus is there.
- Case1
BusTelemetryHistory
| extend BusState=Properties.BusState
| where BusState == "Arrived"
| extend Delay=datetime_diff("second",Timestamp,ScheduleTime)
| where StationNumber ==0
| summarize TotalDelay=sum(Delay) by BusLine
- Case2
BusTelemetryHistory
| extend BusState=Properties.BusState
| where BusState == "Arrived"
| extend Delay=datetime_diff("second",Timestamp,ScheduleTime)
| summarize AveDelay=avg(Delay) by BusLine
点赞过百发布更多Case
网友评论