Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
=Count(DISTINCT If(Count(ORDER_ID)>= 2, SHOPIFY_ORDER_ID))
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))
It worked!
Thank you 🙂