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.
[Measures].[Issue status] = ‘Request Opened’ AND
[Measures].[Issue Sprint Status] = ‘None’
Try this code with tuples instead:
[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