Hi,
I’ve built a report that gives me the issue status history for each date of a selected sprint. However, the transition status history doesn’t end with the last date of the sprint, it continue to the current day. I know why it’s doing it but have failed to be able to prevent it.
First, here’s a picture of the report (I have sprints in Pages so I can filter by one sprint at a time). In this case the sprint ended on August 18th:
I am using the out-of-the-box Issues history measure. It is defined as:
Cache( NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember), Cache([Measures].[Transitions to] - [Measures].[Transitions from]) )) + [Measures].[Transitions to] - [Measures].[Transitions from] )
I understand that the measure is summing up all previous time periods from today. But how do I limit it to the Sprint I’ve selected in the filter? I only want to see the issue history from the selected sprint’s start date until its end date.
I tried the following but get no results. The idea being that I’d create a set of dates between the sprint’s start/end date. I’m still a novice so it’s difficult for me to troubleshoot. Any ideas??
Cache( Sum( Filter(PreviousPeriods([Time].CurrentHierarchyMember), DateBetween( [Time].CurrentMember, [Sprint].[Sprint].CurrentMember.getDate('Start Date'), [Sprint].[Sprint].CurrentMember.getDate('End Date') ) ), Cache([Measures].[Transitions to] - [Measures].[Transitions from]) ) )
Thanks!!
-jj