Average Working days in transition status per 3 weeks in last 4 month

[Victor_Mendez]

Hi,

I tried to calculated the average of working days in transition status per 3 weeks in last 4 month, using this

Avg(
LastPeriods(3, [Time.Weekly].[Week].DateMember([Time].CurrentHierarchyMember.StartDate)),
CoalesceEmpty([Measures].[Workdays in transition status],0)
)

But I can’t create a custom hierarchy like “per 3 weeks” (i do not have the option), so i only can use default hierarchy . as a result i have this

is average working days in transition status per 3 weeks in last 4 month, but group by weeks, and i need to group by 3 weeks and then calculate the average of these

i wonder if anyone can help me about it, i’ll really appreciate

[lauma.cirule]

Hi @Victor_Mendez,

Starting eazyBI version 5.3 it is possible to define a custom multi-weekly hierarchy in the Time dimension.

You can use the Workdays in transition status with three week hierarchy as well as divide the number with 3 to get an average per three weeks.

Lauma / support@eazybi.com