Calculating Average Hours Per Quarter

I am trying to calculate the average amount of hours spent on Projects per Quarter, I have been able produce the 4 week moving average.

and have produce a weekly break down of hours spent

But I have been unsuccessful in producing a Quarterly Calculated measure that takes in all the hours over the quarter to get an average.
Any help would be appreciated

1 Like

Hi @WilliamTrebes

Function LastPeriods() dynamically gives you the set of the selected Time dimensions member and the given number (minus one) of the previous Time members (of the same level) of the selected one: Calculated members in Time dimension

To get a previous quarter when a specific week is selected, you may use (LastPeriods(12, [Time].CurrentHierarchyMember) instead: it would give the set of the selected week and 11 previous weeks from that week.


Hi @WilliamTrebes ,
I wanted to let you know that we have released eazyBI version 7.0 recently. We included in this version an option to define custom time hierarchies. See the documentation for different examples: Custom time hierarchies

Please see a list of all changes: Changelog - eazyBI for Jira.

Gerda //