Help in Expression

[#1]

Hi,

I want to display the count of accounts  in text box .

If same Account is covered in 2 Meeting ID's  then count is 2  and it is unique group by Meeting ID

I tried with aggr by Meeting ID .

Meeting ID	Account	Name
M01	A001	A
M02	A001	B
M03	A002	C
M05	A003	D
M06	A003	E
M07	A004	F

Thanks in advance

[lironbaram · Accepted solution]

hi

if for each account you have only one record for each meeting

you can simply do: count(distinct [Meeting ID])

using aggr for meeting you can use

sum(aggr(count(distinct Account),Meeting ID))

[#3]

Hi Kavya,

what is the exact output are you expecting.

[#4]

[#5]

Hi ,

I am expecting output like this.With Unique group by Meeting ID

If same account is covered in 2 meeting ID's  then count is 2 .

Meeting ID	Account ID	Name	Count(Account ID)
M01	A001	A	2
M02	A001	B
M03	A002	C	1
M05	A003	D	2
M06	A003	E
M07	A004	F	1

[#6]

Thanks for your response