Calculating Average Hours Per Quarter

Questions & Answers
,
1

Hi,
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.

image
image715×242 10.6 KB

and have produce a weekly break down of hours spent
image
image1874×692 108 KB

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
2

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.

Best,
Ilze, support@eazybi.com

3

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.

best,
Gerda // support@eazybi.com