Hints for Kusto Detective Agency

Link

1. Welcome part. Just check the dashboard and the missing bus is there.
2. 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

3. Case2

BusTelemetryHistory
| extend BusState=Properties.BusState
| where BusState == "Arrived"
| extend Delay=datetime_diff("second",Timestamp,ScheduleTime)
| summarize AveDelay=avg(Delay) by BusLine

点赞过百发布更多Case