Rank Help

[Vittore8]

Hi, please tell me how I can rank, by this expression
=Aggr(Rank({<main_category={"Games"},launched={">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}>} backers),(backers, (Numeric, Ascending) ))

[sunny_talwar · Accepted solution]

Rank cannot use set analysis, you need to use Only() or Sum() or another aggregation function here... may be try this

=Aggr(
  Rank(
    Only({<main_category={"Games"},launched={">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}>} backers)
  )
,(backers, (Numeric, Ascending) ))

[Vittore8]

Thank you very much,why is it used here only() ?

Because there will be no duplicate values for each field?

[sunny_talwar]

I guess I used Only because you were using backers. backers = Only(backers). The benefit of Only() is that it allows you to use set analysis.