Rank top 10

[mparker123]

Hello All,

I am trying to only show the top 10 projects in a line chart. I am unable to use the Dimension Limits to do this. I have two expression that I would like to put the "rank function" in. Just do not know where it should go or how it works.

Formula 1: Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS))

Formula 2: Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)

[sunny_talwar · Accepted solution]

May be this

If(Rank(Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS))) < 11, Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS)))

If(Rank(Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)) < 11, Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS))

[Anonymous]

kudos to sunny ,,