Top 10?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Could someone tell me how ranked top 10 companies according to the selected best sales year?

Thank you

Re: Top 10?

Tue, 06 Sep 2016 03:36:37 GMT

This might help.

Anonymous — Tue, 06 Sep 2016 03:54:10 GMT

Thank you!

amit_saini — Tue, 06 Sep 2016 04:19:38 GMT

Hi,

Ranking Concept:

Syntax:

=rank(sum(Investment),1,1)

AND

=aggr(if(Rank(sum(Investment))<=3,Investment),Investment) (For calculating Top 3)

AND

=if(rank(sum(Investment),1,1)=1,'# 1')

I have a data table which includes the following fields; SystemID, Timestamp.

I want to derive a new field in this table which ranks the Timestamp in ascending grouped by SystemID

I'd like to do this in the script.

SystemID, Timestamp, [Rank]

00001, 01/01/2013 10:00, 1

00001, 01/01/2013 12:00, 2

00001, 01/01/2013 12:30, 3

00002, 01/01/2013 11:00, 1

00002, 01/01/2013 12:12, 2

00003, 01/02/2013 10:30, 1

Syntax:

LOAD

SystemID, Timestamp,

if(SystemID=previous(SystemID),peek('Rank')+1,1) as Rank

FROM ...mysource...

ORDER BY SystemID, Timestamp;

Thanks,