Forum Discussion

Kylebigelow's avatar
Kylebigelow
New Member
7 years ago
Solved

Calculate Moving Average with Sum and Filter

Dear BI Community,

I have a simple metric I am trying to capture:

Average # of 'hours' for statuskey= "unavailable - technical issue" per 'agent' for the last week, month, etc.

I have four columns involved: 'statuskey' 'hours' 'agent' 'nomdate'

Data set example:
Statuskey Hours. Date. Agent.
Available 2. 10/13/18. Mark
On a call 3. 10/14/18. Sally
Unavailable - technical issue 1. 10/15/18. Adam
....

Thank you
  • Have you checked out the Rolling Average Quick Measure? Right-click your field, choose New Quick Measure and then Rolling Average.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Have you checked out the Rolling Average Quick Measure? Right-click your field, choose New Quick Measure and then Rolling Average.