Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
count(distinct(if(PAYMENT_TYPE_CD='46' and SUM (BOOKING_INVOICE_AMOUNT>=1000,Booking_ID)))
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)
Thanks Guys.
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