Set Analysis error

[didierodayo]

Hello,

I can't get this set analysis expression to work. I have bar chart with following :

Dimension

Booking_ID

[BOOKING DATE]

expressions

1-

COUNT({<PAYMENT_TYPE_CD={'20'}>}DISTINCT([BOOKING DATE]))

2-

COUNT({<PAYMENT_TYPE_CD={'46'}>}DISTINCT([BOOKING DATE]))

it is working fine BUT Because of the high load we have decided to add WHERE the PAYMENT_TYPE_CD={'46'} ,SUM (BOOKING_INVOICE_AMOUNT>=1000 and RETURN only the booking_IDs that have a total payment_type_code>=1000.

I welcome your ideas.

Thanks

[#2]

count(distinct(if(PAYMENT_TYPE_CD='46' and SUM (BOOKING_INVOICE_AMOUNT>=1000,Booking_ID)))

[tamilarasu · Accepted solution]

Hi Didier,

May be this?

1. COUNT(DISTINCT  {<PAYMENT_TYPE_CD={'20'},BOOKING_INVOICE_AMOUNT={"=Sum(BOOKING_INVOICE_AMOUNT)>=1000"}>} Booking_ID)

2. COUNT(DISTINCT  {<PAYMENT_TYPE_CD={'46'},BOOKING_INVOICE_AMOUNT={"=Sum(BOOKING_INVOICE_AMOUNT)>=1000"}>} Booking_ID)

[didierodayo]

Thanks Guys.

[maksim_senin]

Hi Didier,

From performance point of view it's better to calculate this in the load script.

Also please give a look at P() and E() set analysis functions.

Best regards,

Maxim