Right expression?

[#1]

Hi,

I have a column Product with values Soaps Dove, Soaps Caramel, Soaps Lux, Soaps Santhoor, Detergents XX,Detergents YY,Detergents DDFDG .

I would need to show the count of IDs which will start only with Soaps in dimension

I tried using below

Dimension: =IF(WildMatch(Product,'Soaps*'),Product)

Expression: Count(Distinct(ID))

But I doubt whether the expression is correct or not could anyone suggest me.

Thanks.

[m_woolf · Accepted solution]

Try:

count(distinct {<Product = {'Soaps*'}>}ID)

[#3]

Thanks. It is showing 'Error in calculated condition'. sorry if I am wrong.I don't want to change expression instead want to change dimension.

[jonathandienst]

Hi

You could just use Product as the dimension and Count({<Product={"Soaps*"}>} Distinct ID) as the expression. For the dimension, set the checkbox for suppress nulls.

HTH

Jonathan

Edit: I try to avoid calculated dimensions where possible. This is a case that will perform better with a fixed dimension and a filtered expression.

[#5]

Thanks. Can I use this as dimension

=If(WildMatch(Product,'Soaps*'),Product)

[#6]

Thanks.