Hello, we are trying to create some generic dashboards to be used over multiple projects, all with aligned time frames (sprints).
While implementing cumulative issues created/completed I’ve got to a point where I’m not able to use the selected time interval defined in Pages (Time section). For the member formula I use:
Sum(
{Childrenset([Time].[March Sprint 1]).Item(0):[Time].CurrentMember},
[Measures].[Issues created]
)
But instead of [March Sprint 1] I would like to take the value from the common page setting (which will be the same, Time calculated member.
Or is there any other way of generating a Childrenset based on a time interval?
Thank you very much