4 Replies Latest reply: Jul 26, 2012 11:10 AM by Anne Duffy

# Straightchart presentation conditional Max number

Hi Experts,

I have a straight chart that has [Task] as demension and as experessions has [Number of tasks] , [Rank by number ], [Time to complete], [Ranked by time to complete].

There are a shedload of tasks, I have them sorted by [Ranked by time to complete]. I wish to only show the top 5 of Number.

So using the below sample data = It would show all tasks as far as Pinch as thats the last task in the Top 5.

Is that possible

Thanks

A

 Number Rank # Task Time Rank Time 70 5 Eat 100 1 80 3 Drink 90 2 55 6 Be Merry 80 3 90 2 Dance 50 4 15 7 Fight 40 5 100 1 Clean up 30 6 77 4 Pinch 25 7 2 9 Cook 20 8 10 8 Tidy 15 9
• ###### Re: Straightchart presentation conditional Max number

Actually now I think about it , its probably how I write the expressions

so sum Number only if Rank time is greater than 5

=sum(if(rank(sum(Number)*CycleTime/60)>5,Number))

I've tried the above - it doesnt work - any suggestions greatly appreciated

Thanks

A

• ###### Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A

• ###### Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A

• ###### Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A