I’m sure this is probably very simple but I can’t figure it out. I’m trying to get the TRUE backlog. Open Issues measure doesn’t do it in my instance.
I need to aggregate on both issues not assigned to a sprint [Sprint].[(no board)].[(no sprint)] and [Status].[Request Opened].
I’m assuming I have to somehow do a join to achieve this result, but I can’t get it to work. Appreciate the help!
Tried the following to no avail.
NonZero(count(Filter(Generate(NonEmptyCrossJoin(
[Sprint].[Sprint].Members, [Status].CurrentHierarchyMember),
[Sprint].CurrentMember),
[Measures].[Issue status] = ‘Request Opened’ AND
[Measures].[Issue Sprint Status] = ‘None’
)))
Hi,
Try this code with tuples instead:
(
[Measures].[Issues created],
[Status].[Request Opened],
[Sprint].[(no board)].[(no sprint)]
)
It would return the number of all issues created (and imported in eazyBI) without any sprint from status “Request Opened” (current status).
Martins / eazyBI support