comma separated string field value count

[satheshreddy]

Hi All,

Can anyone help me on the below:

I have mapping table data and comma separated  field based on which I have to count the volume.

my expected count should as below:

1) count of branch only

2) count of branch and machine assisted only.

likewise for each value in value field(Mapping table).

Thanks in advance.

[satheshreddy]

plz find attachment

CHANNEL_DESC	Value
COUNTER	Branch
IPAD	Branch
SR_BRANCH	Branch
BRANCH	Branch
AO_BRANCH	Branch
LS_BRANCH	Branch
RS_BRANCH	Branch
CMP_BRANCH	Branch
EXASD	Machine Assisted
KIOSK	Machine Assisted
QSP	Machine Assisted
MCCA	Machine Assisted
ASD	Machine Assisted
ATM	Machine Assisted
ATMQR	Machine Assisted
CCDM	Machine Assisted
IVR	Machine Assisted
CMP_POST	Mail
MN_POST	Mail
AO_BMB	Mobile
PDC_BMB	Mobile
BMB	Mobile
AO_BMBI	Mobile
AO_PINGIT	Mobile
PINGIT	Mobile
AO_PINGITI	Mobile
CMP_WCHAT	Online
AO_CO_UK	Online
CMP_CO_UK	Online
AO_ROLB	Online
ROLB	Online
INTERNET	Online
MN_ROLB	Online
PDC_ROLB	Online
CMP_ROLB	Online
CO_UK	Online
PDC_CO_UK	Online
EXCO_UK	Online
RS_OTHER	Others
MULTI CHAN	Others
CMP_OTHER	Others
BUSINESS	Others
AO_OTHER	Others
SR_OTHER	Others
AO_TEL	Telephone
SR_TEL	Telephone
RS_TEL	Telephone
Skybranch	Telephone
LS_TEL	Telephone
CMP_TEL	Telephone
TEL	Telephone

[vishsaggi]

‌nnot sure exactly your output may be try this

= count({<Value = {‘Branch’} >} channel_desc)

= count({<Value = {‘Branch’, ‘Machine Assisted’} >} channel_desc)

[satheshreddy]

ATM

ATM,BMB

ATM,BMB,BRANCH

ATM,BMB,BRANCH,CO_UK

ATM,BMB,BRANCH,CO_UK,MACHINE

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,TEL

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,TEL,WCHAT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,WCHAT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,TEL

[vishsaggi]

‌ddoesn’t help. What is the output result you are expecting?can you elaborate?