Forum Discussion
Date range with time window to do SLA statistcs
Dear community, i struggle around with following: I need to write a query which displays availabilityResults within business hours and out of business hours. Mo-Fr: 08:00 - 18:00 and out...
Already handled SLA hours. No i struggle around with SLA_days:
let SLA_hours = range x from 8 to 18 step 1;
let SLA_days = range y from 1 to 5 step 1;
availabilityResults
| where timestamp >= datetime('2018-03-27') and timestamp <= datetime('2018-07-05') and location == 'West Europe'
| project timestamp, ['day']=dayofweek(timestamp), ['hour']=hourofday(timestamp), success
| join kind=inner SLA_hours
on $left.hour == $right.x
| summarize count(success) by timestamp
| extend availabilty = (count_success / 12)*100
| summarize avg(availabilty) by bin(timestamp, 1d)
Problem now is, dayofweek() is a timespan which cannot be joined.
How can i do this?