Set anlysis

[jyothish8807]

Hi,

I have following data:

Name	Type
a	1
b	1
c	2
d	3
e	1
f	2
a	2
a	2

Now i want Count of Type for all users where count is >2.

Regards

Jyothish KC

[saumyashah90]

count(<{Count(Type)>={'2'}}> Type)

[christian77]

Your post is not very clear to me.

count( {$< Type={'>2'}>} distinct Name)

or

count( {$< Name={'=count(Name)>2'}>} distinct Name)

Users = Name?

Count = Count Name appearings?

Count = Count Type appearings?

[CELAMBARASAN]

Try this

Count({<Name={"=Count(Distinct Type)>2"}>} Distinct Type)

[MayilVahanan]

HI

PFA

[rustyfishbones]

You can try this

[#7]

Hi

PFA

[sudeepkm]

have you checked using aggr() like below. You can use the below expr in a list box which will show you the names where count is >2.

=if(aggr(count(Type),Name)>2,Name)

[jyothish8807 · Accepted solution]

Hi,

My requirement if little more specific. My output columns should be like this:

Name	1	2	3
a		2

There should be two condition:

Type should be '1' and count >=2. for second column.

Type should be '2' and count>=2. for third column.. and so on.

Regards

Jyothish KC