topic Re: Set analysis or if statement in App Development

Set analysis or if statement

chloe — Thu, 08 Jun 2023 14:22:28 GMT

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 — Thu, 08 Jun 2023 16:32:06 GMT

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

Digvijay_Singh — Thu, 08 Jun 2023 21:16:05 GMT

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 — Sun, 11 Jun 2023 06:28:38 GMT

It worked!

Thank you 🙂