Forum Discussion

Borednlost's avatar
Borednlost
Regular Visitor
5 years ago

Intraday Rolling Average

Hi all,

 

I'm very new to PBi and am trying to calculate SLA adherence at a call centre during a day.
My data has the % of calls handled in SLA by 30min interval, but all the rolling average solutions I've seen use 'DATESINPERIOD'.  A days data looks like:

IntervalsSLAExpected Result
7:00:00 AM100100
7:30:00 AM100100
8:00:00 AM8695.33333333
8:30:00 AM1775.75
9:00:00 AM3968.4
9:30:00 AM5666.33333333
10:00:00 AM757.85714286
10:30:00 AM050.625
11:00:00 AM645.66666667
11:30:00 AM041.1
12:00:00 PM037.36363636
12:30:00 PM034.25
1:00:00 PM031.61538462
1:30:00 PM3331.71428571
2:00:00 PM029.6
2:30:00 PM027.75
3:00:00 PM10032
3:30:00 PM9335.38888889
4:00:00 PM033.52631579
4:30:00 PM031.85
5:00:00 PM030.33333333
5:30:00 PM5031.22727273
6:00:00 PM8033.34782609
6:30:00 PM10036.125
7:00:00 PM10038.68
7:30:00 PM10041.03846154
8:00:00 PM10043.22222222
8:30:00 PM10045.25

2 Replies

  • kumar27's avatar
    kumar27
    Icon for Advocate V rankAdvocate V
    5 years ago

    can you expain a bit more? do you want to use datesinperiod ? or the goal is to get the rolling average as in column C?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Borednlost , If Interval is datetime column then try a new column

    new column =
    avergageX(filter(Table,[interval] >earlier([interval]) -time(23:59:29) ),[SLA])