Count Set analysis Help

[Vittore8]

Hi,please tell me how to get it number 7 use set analysis, where avg > 1000

Count(
Aggr(Sum({<state={"successful"},main_category={"Food"}>} usd_pledged_real / backers)) -- for example this, but I don't know if this is the right way

[Gui_Approbato · Accepted solution]

Try this:

Count(

Aggr(

if(        Sum({<state={"successful"},main_category={"Food"}>} usd_pledged_real / backers) >1000 ,Name),

Name))

[Vittore8]

[Vittore8]

Thank you very much, removed the extra spaces and works!