Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) ))
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) ))
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) ))
Thank you very much,why is it used here only() ?
Because there will be no duplicate values for each field?
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.