Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
I am trying to color a pie chart using the following expression :
=if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 1,
Yellow(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 2,
lightblue(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 3,
lightred(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) > 3,
lightred(),
green()))))
It works when the expression = 1 , 2, 3 , but it does not work when the expression is > 3.
Any ideas ?
thanks a lot
Philippe
Hi Philippe,
There is two lightred one for = 3 the other for > 3 try changing the second for an other color
=if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 1,
Yellow(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 2,
lightblue(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) = 3,
lightred(),
if (aggr(SUM({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"},FileType=>} PHASEDCALLS)-
count({<RecordType={'CALL'},FileType=,CUSTOMER_ID=p({<CUSTOMER_ID={"=sum(PHASEDCALLS) > count(DISTINCT EVENT_ID)"}>}CUSTOMER_ID)>} Distinct EVENT_ID),CUSTOMER_ID) > 3,
lightred(),
green()))))
Regards.
Luc
I changed the second lightred to an other color and it does not change anything.
Thanks
Philippe
can you share a sample app?
Unfortunatly the app is really big (more than 600mb).
I will try to create a small App.
Thanks for your help
Philippe