Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Two fields named Call_Type and Call_Sub-type.I have used this fields as Filters.
I have taken CALL TYPE As Dimension and used below set analysis expression.It is three parts.
=Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EID)
-
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'911'},CALL_SUB_TYPE={'COM'}>}EID)
-
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'ANIMAL'},CALL_SUB_TYPE={'DEAD'}>}EID)
Now my requirement is
1.This Total expression(with all the three parts) is valid only when nothing is selected in call_type and CAll_sub-type Filters.
2.if user selects except Call-Type=911,CALL-SUBTYPE=COM and CALL-TYPE=ANIMAL ,CALL_SUB_TYPE=COM
then only
2.if user selects Call-Type=911,CALL-SUBTYPE=COM then First and second part in the above expression is valid
3.if user selects CALL_TYPE= animal, CALL_SUBTYPE=DEAD then First and third part in the above expression is valid
Please help me to write this condition in set analysis by if condition .
Thanks
Hi
I can able to understand your second (2.) query . try the below expression
2.if user selects Call-Type=911,CALL-SUBTYPE=COM then...................
If(AGGR(SUM(1), CALL-SUBTYPE, Call-Type)>0, (Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EID) -
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'911'},CALL_SUB_TYPE={'COM'},STATUS_CODE={'12'}>}EID) VALID))
//OR try this
If(Call-Type=’911’and CALL-SUBTYPE=’COM’,
(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EID)-
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'911'},CALL_SUB_TYPE={'COM'},STATUS_CODE={'12'}>}EID) VALID))
Not tested but give it a try;
=Count({<CALL_TYPE=,CALL_SUB_TYPE=,CALL-TYPE=,CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EID)
-
ALT(
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE*={'911'},CALL_SUB_TYPE*={'COM'},STATUS_CODE={'12'}>}EID),0)
-
ALT(
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE*={'ANIMAL'},CALL_SUB_TYPE*={'DEAD'},STATUS_CODE={'12'}>}EID),0)
Thanks for your reply
But when i selected calltype 911 and call subtype com then need to get the count of 1st and 2nd part count only in the expression.
By the selection count is not changing
Ok , try each of the expressions separately in a text box
=Count({<CALL_TYPE=,CALL_SUB_TYPE=,CALL-TYPE=,CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EID)
-
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE*={'911'},CALL_SUB_TYPE*={'COM'},STATUS_CODE={'12'}>}EID)
-
Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE*={'ANIMAL'},CALL_SUB_TYPE*={'DEAD'},STATUS_CODE={'12'}>}EID)