I've tried to write a Calculated Member in the Time Dimension like so:
Aggregate(Filter( [Time.Weekly].Members, DateBetween([Time.Weekly].CurrentMember.Name,'1 month ago','1 month from now') ))
but it doesn't work. It gives me this error:
Error is because you defined member in default Time hierarchy and formula uses Time.Weekly hierarchy. Please change [Time] to [Time.Weekly]. There is some small adjustments needed for this formula, too. You probably wanted only week members, not all including dates. And better use StartDate instead of member name.
Aggregate(Filter( [Time.Weekly].[Week].Members, DateBetween([Time.Weekly].CurrentMember.StartDate, '1 month ago','1 month from now') ))
That appears to be close because I get the totaled values in the Calculated Member column. I know I gave this same code a shot, (minus the .StartDate tip vs membername, that I didn't know!)
However, when I attempt to drill-into or expand this Calculated Member, I receive the same error listed in my question above. You are correct to assume that I am interested in the Week members, these results are used in reports concerning various past, current, and future sprints.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG