Multiple Sprint Overview

Questions & Answers
1

I am using the Multiple Sprint overview report. The backlog field is not accurate. When I reviewed the Define report specific calculated member formula for backlog it is only showing “To Do” stories. I tried multiple time to get it to take stories in “ready” status and “to do” but I keep getting an error. Can you please help with a formula so it will show stories in the backlog under status "To Do’ and “Ready”

calculated measure currently for the backlog
– annotations.drill_through_non_empty=false
([Measures].
[Measures].[Original estimated hours],
[Status.Category].[TO Do],
[Sprint].CurrentHierarchy.Levels(“Sprint”).Members.Item(“(no sprint)”))

image
image1920×953 107 KB

2024-01-18_12-13-23
2024-01-18_12-13-231920×953 127 KB

2

Hi,

If the To Do Status category does not completely cover the backlog items, you may create a calculated measure in the Status dimension aggregating the statuses you need.

The following formula is for filtering issues in two statuses:

Aggregate(
  {
   [Status].[To Do],
   [Status].[Ready]}
)

image
image1710×1240 221 KB

The backlog formula should refer this member:

([Measures].[Original estimated hours],
[Status].[Backlog statuses],
[Sprint].CurrentHierarchy.Levels(“Sprint”).Members.Item(“(no sprint)”))

Kindly,
Janis, eazyBI support