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)

[Anonymous]

Hi

What is the Dimension , you will require to choose top project ?

Hours Or date ?

[mparker123]

I want to show the top 10 based on the number of Hours they have.

[Anonymous]

=if(Aggr(Rank(Sum(Hours)), DEPT)<=10, DEPT , 'Others')

[mparker123]

I need to keep the formulas above I just want to add top 10 into the expression

[sunny_talwar]

You want to look at top 10 based on rank of which expression?

[mparker123]

I have two charts each expression is in a different chart so I need the top 10 of both formulas based on the number of Hours.

[its_anandrjs]

Can you share some sample data for this.

[mparker123]

Unfortunately I can not.

[Anonymous]

Like this ?

rank(sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)<=10)