count common value

[omid5ive]

hi

i have a table that have 2 field, project and vendor

i need to create pie that show how many vendor work on just one project and how many vendors work s on more than one projects

can any one help me for this two expression

the table like below

Vendor	Project
A	1
A	2
B	3
C	4
C	5
D	6
E	7

in this sample i need the pie chart that show first slice with value 2 and second slice with 3

[omid5ive · Accepted solution]

i think i can find it

=count( DISTINCT if(Aggr(Count(distinct ProjectName),vendor_name)>1 ,vendor_name,Null())) for more than one

=count( DISTINCT if(Aggr(Count(distinct ProjectName),vendor_name)=1 ,vendor_name,Null())) for just one