Removing issues not in a sprint from eazyBI reports

[Justin Leader]

Hello!

In our eazyBI listing of issues grouped by sprint, there is a row of (no sprint). Any thoughts on how to remove it, either from the row, or from the calculation of measures in the columns?

[Lauma Cīrule]

Hi Justin,

If you only wish to remove member from table, you can click on it and select 'Remove'.

It would also be possible to create a calculated member in Sprint dimension that uses the Except(..) function as follows

Aggregate(Except(
  [Sprint].[Sprint].Members,
  [Sprint].[(no board)].[(no sprint)]
))

I also created an example report that uses the calculated member without (no Sprint). I sent you more details in the e-mail as well.

Kind regards,
Lauma / support@eazybi.com