Filter out 'none' from the reports

Hi team/@lauma.cirule

I have a very general question. I have checkbox as A with options Yes and No. When an issue is created without selecting any of the option (which we are allowing ), the eazyBI shows ‘none’ in the report for columns where A dimension is added. I basically DON’T want to see ‘none’. I just want to see issues with yes and No.
Again, I have one more checkbox named B. It has just one option in it. When an issue is created without selecting it, in eazyBI the report again shows ‘none’ for issues with no value of B.
How do I resolve this issue. I don’t want to see none in reports.

eazyBI by default generates (none) members to represent the issues with no values in the custom field. However, All member contains both issues with values and issues without values. You would like to use multiple member selection or define a calculated member using function Except in the dimension or y listing particular member names explicitly. Here are both examples.

I would use a dimension name Valid as an example, please use your custom field name instead of the name Valid in the formulas below.

Except:

Aggregate(
  Except(
    [Valid].[Valid].Members,
    [Valid].[(none)]
  )
)

[Valid].[Valid] represents a level Valid of a dimension Valid.

List

Aggregate({
        [Valid].[Yes],
        [Valid].[No]
    })

Please fill in values using autocomplete to avoid any typo errors.

Daina / support@eazybi.com