View by sprint Past, Active and Future

Questions & Answers
1

Hi,

I created the following sprint member

–closed sprints are displayed first (by start date), then active sprints (by start date)
Aggregate
(
Union
(
– set with closed sprints since specified date
Order
(
Filter
(
[Sprint].[Sprint].Members,
DateBetween([Sprint].CurrentMember.get(‘Complete date’), ‘01 NOV 2019’, ‘today’)
),
[Sprint].CurrentMember.get(‘Complete date’),
BASC
),
– set with active sprint and future sprint
Order
(
Filter
(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean(‘Closed’)
AND
( NOT isEmpty([Sprint].CurrentMember.get(‘Start date’))
OR [Sprint].CurrentMember.Name <> ‘(no sprint)’)
),
[Sprint].CurrentMember.Name,
BASC
)
)
)

Now I would like to see a “Sprint” who would contain what’s left in the “backlog”

Thanks

V

2

Hi @Vero,

eazyBI keeps all issues that are in backlog in the Sprint dimension, value (no board). You create a tuple with this measure together with unresolved measure Issue due or Story Points due to get what is left in ‘backlog’. Then you can apply in Pages filters that identify for which project or team is this report.

(
  [Sprint].[(no board)],
  [Measures].[Issues due]
)

Additionally, you can check this community answer to see how you can get information about backlog within eazyBI - How to generate report of Backlog % for a particular sprint?