"Last Closed Sprint" is displaying old sprints

Questions & Answers
1

Hi,
i have a report that uses, a row, a calculated member for “Last Closed Sprint”.

  1. In the beginning, I closed sprint A and opened B and the result showed me sprint A results. This is good.
  2. Then closed B and opened C. i expected to see B results, but now i have two rows. on the “last closed sprint” (i.e. B) and one for A.
  3. When i closed C and open D i will have A, B and C as the “Last closed Sprint”.

for (2) i want to see only B and for (3) only C.

This is how “Last Closed Sprint” is defined:
Aggregate(
Tail(Order(
Filter(ChildrenSet([Sprint].[MyBoard]),
[Sprint].CurrentHierarchyMember.getBoolean(‘Closed’) AND
NOT IsEmpty([Sprint].CurrentHierarchyMember.get(‘Complete date’))),
[Sprint].CurrentHierarchyMember.get(‘Start date’),
BASC
), 1)
)

2

Hi @meravbe if you are retrieving only one Sprint.
Why do you want to order? You will receive only one.

The issue could be on the Filter for the CHildrenSet you are reading.

You can check with this code to read the last:

Aggregate(
  Generate(
  -- get all boards
    [Sprint].[Board].Members,
    -- access all children - sprints from the board and get the last closed
    Tail(
      Filter(
      [Sprint].CurrentMember.Children,
      [Sprint].CurrentMember.GetBoolean("Closed")),
      -- 1 last (from Tail) closed sprint from a board
      1)
      -- address the first (0) member from a set
      .Item(0)
  )
)
3

@Nacho thanks. I tried and got this error:
Formula is not valid:
More than one function matches signature ‘.Members’; they are: .Members, .Members

4

It is weird because it is copied and pasted from the eazyBI Demo account, and I copied into our project too.

Check if updating the

[Sprint].[Board].Members,

With only
[Sprint].[Name of your board]

5

Hi, @meravbe

Welcom to the eazyBI community.
Thank you @Nacho for the answer.

The formula should work.

Please send the report definition, problem description, and printscreen to support@eazybi.com

Kindly,
Ilze

6

Hi,
the formula works, but i still face the same problem i complained about:

image
image313×140 2.42 KB

After iteration 4 was closed, it appeared as a new row in the table. i only want to see a single row. the Last Completed Sprint

7

That a different level. I guess that will disappear if you go into the Sprints Dimensions, select “All Sprints” then in the report click on the “+” to show all of them.
After that “close the All SPrints” clicking on the “-” and then deselect the “All Sprints” in the Sprint DImension.

FInally, click on the “+” for the “Last Completed xx Sprint2” to show only them

8

@Nacho ,thanks. And that will prevent from an extra row to appear next time a sprint closes?

9

It should be, because you are adding into the report only the filter applied for the “Last 2 Sprints”