denseRank for totals

Question & Answer
,
1

Hi,
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).

image

Thanks in advance

2

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

3

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

1 Like