Statistics per time period

Is it possible to have a calculated measure that is applied to the expanded time dimension.

For example, the “Average” calculated measure, calculates the average across the whole data set. If I have a time dimension of years, and I expand to show quarters, is it possible that the average is the average over each quarter, week etc…?

In the example below, I’d like to see the average for each quarter, not the whole data set.

Hi,

The following formula calculates the average of all the lower level periods:

Avg(
 [Time].CurrentHierarchyMember.Children,
  [Measures].[Open issues]
)

Kindly,

Janis, eazyBI support

1 Like