How I can countif in basis Aggr?

[dwenlvov]

Hi!

I have table (id, rating)

How can I use set analysis in the basis  Aggr(Count(rating), id)?

I mean(example. and I know it's wrong:) )  =Count({< Aggr(Count(rating), id) = {">=$('30')"}>}  Aggr(Count(rating), id))

[Kushal_Chawda]

@dwenlvov  may be like below

=count({<id ={"=Count(rating)>=30"}>}id)

[dwenlvov]

nope 😞 result 0

it's not true

[dwenlvov]

maybe this will help explain

[MayilVahanan · Accepted solution]

HI @dwenlvov 

Kush expression will work fine. 
other method, You can try like below

Sum(Aggr(if(Count(rating)>=30,1,0),Id))

[dwenlvov]

Yes! THKS!