Top 10 on expression with agrr

[#1]

hello,

If I have table like this:

worker id	% profit
123	60%
234	70%
345	80%
456	60%
567	50%
678	100%
789	70%
891	90%
912	80%
913	40%
914	70%
915	30%
916	20%
917	15%
918	10%
919	5%

I want to do something like top 10, but to get 10 top values of profit' and not 10 rows:

worker id	% profit
678	100%
891	90%
345	80%
912	80%
234	70%
789	70%
914	70%
123	60%
456	60%
567	50%
913	40%
915	30%
916	20%
917	15%

I can't calculate the % profit in the script, just in the expression of the table. (the calculate depends in the permissions (admin,user1..)

[avinashelite]

If your using the Straight table then

Go to chart properties > Dimensions limit and let show Top 10

[#3]

but it will give me 10 rows, it's not what i want. I want 10 top values. if I have 100% profit 3 times so I want to see all of them.

[beck_bakytbek]

Hi Nofar,

try this: if(aggr(Rank(Sum(%Profit)),worker_id)<=10, worker_id,Null()) and dont forget to supress zero value

i hope that helps

beck

[avinashelite]

could you elaborate bit more ? how we will identify the 100% profit? their should be a column to identify the last profit and the current value rite ? could you share the complete info  

[jonathandienst]

You might have to first determine the value of the 10th ranked profit and return all the profit values greater than that, although that will usually return 10 values, rather than the 15 you expect in your sample.

You might have to do some work in the script to make your exact analysis as I suspect that it is difficult to hit a moving target* like this solely in the front end.

* because you might get 10, 11, 12, ... rows for your Top 10.