Set analysis or if statement

[chloe]

Hi,

I need to calculate -> count distinct of order_id but only when the count of order_id is >= 2.

This calculation should be on KPI object. 

I tried -

if(count(ORDER_ID)>= 2 , count(distinct SHOPIFY_ORDER_ID))

When I tried it in "table" it worked but on KPI it didn't.

Would appreciate your help.

Thanks.

[BrunPierre]

=Count(DISTINCT If(Count(ORDER_ID)>= 2, SHOPIFY_ORDER_ID))

[Digvijay_Singh · Accepted solution]

 if @BrunPierre expression troubles due to nested aggregation, you may try adding Aggr in between, but cannot be sure without testing

=Count(DISTINCT Aggr( If(Count(ORDER_ID)>= 2, SHOPIFY_ORDER_ID),SHOPIFY_ORDER_ID))

[chloe]

It worked! 

Thank you 🙂