denseRank for totals

i’m currently trying to assign ranks for a totals (calculated by runningSum function). Apparently denseRank/rank don’t work with calculated field arguments and i’m getting error when trying to save the field. Is there any other workaround for such kind of issue? I’m basically trying to retrieve top 5 items with biggest total sum assigned (cannot do it by filter neither).


Thanks in advance

Hi @Rad

This might need to be done at the SQL level. Either the running sum calculation or the denseRank.

I was thinking about using a PRE_AGG calculation of sumOver however, you can’t have PRE_AGG arguments with a runningSum

Hi @Max i solved it by custom sql, thanks.

1 Like