Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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))
kudos to sunny ,,