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 co...
  • Greg_Deckler's avatar
    7 years ago

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