Count with Aggr in Front-end expression

[#1]

Hi All,

Any one help me to solve below issue

I want Count of ID field as final output in Front end expression by using ID, Indicator  and Generatedflag. No change on count by selections (static).

ID	Indicator	Converted	Generatedflag	Amount	Count of ID
123	Y	Y	Y	1000	2
123	N	Y	Y	2000	2
124	Y	N	Y	200	2
124	N	N	Y	144	2
124	N	N	Y	123	2
125	N	N	N	500	1
126	Y	N	N	600	2
126	N	N	N	567	2
126	N	N	N	500	2
126	N	N	N	460	2
127	N	N	N	570	1
127	N	N	N	679	1
127	N	N	N	789	1
128	N	N	Y	567	1
128	N	N	Y	400	1
129	Y	Y	N	400	2
129	N	Y	N	340	2
129	N	Y	N	550	2
130	Y	Y	Y	340	1

[jonathandienst]

I suggest you give some examples of what output you require.

[Anil_Babu_Samineni]

What was the logic behind of Count ID. I am not getting as you expected. I've tried many times.

Count({<Generatedflag = {'No'}, Converted = {'Yes'}>} TOTAL ID)

[#4]

Hi All - Thanks For Responding

My Requirement is:

Case1: If ID having indicator 1Y and 1N distinct Count of ID = 2 --->EX ID 123   (with out distinct count of ID =2)

Case2: If ID having indicator 1Y and >1N distinct Count of ID = 2 --->EX ID 124   (with out distinct count of ID =3)

Case3: If ID having indicator 1N  and no Y distinct Count of ID = 1 --->EX ID 125  (with out distinct count of ID=1)

Case4: If ID having indicator >1N and no Y distinct Count of ID = 1 --->EX ID 127 (with out distinct count of ID=3)

Case5: If ID having indicator 1Y no N distinct Count of ID = 1 --->EX ID 130  (with out distinct count of ID =1)

Required this in Set Expression.

[sunny_talwar]

May be this:

Count({1} DISTINCT TOTAL <ID> Indicator&Converted&Generatedflag)