im trying to do a backlog burn-up for a given timeframe (e.g. 3 months) to see how many total issues we have and how we are progressing towards that scope.
Here is the code that I have, which works pretty well up until the current date:
[Measures].[Backlog]=
Cache(
Sum(
PreviousPeriods([Time].CurrentHierarchyMember),
[Measures].[Issue due]+
[Measures].[Issue created]-
[Measures].[Issue resolved]-
[Measures].[Issue closed count]
)
)
It works until the current date. But after that the sum should continue flat because in the future we don’t have issues created. What do I need to change to get that?
There are different ways to count issues in the backlog depending on what you consider backlog items.
Measure Open issues that show unresolved issues over time, if your backlog is based on unresolved issues.
If your backlog is based on the count of issues in a specific status (for instance, the status category To Do), then you would want to use the measure Issues history in the report together with the Transition Status dimension with the selected status or status category for the backlog. It will show how many issues were in this status category at the end of each period.
