cancel
Showing results for 
Search instead for 
Did you mean: 

How to use the ".rankBy()" and ".sortByValue" in the analytics designer

sanpe
Explorer
0 Kudos
3,195

Dear experts,

can someone please explain me how to use the two functionalities ".rankBy()" and ".sortByValue" on a chart/table?

I'm trying to figure it out, but somehow it doesn't want to work on my chart (live HANA connection).

Chart_1.sortByValue("MyMeasureID",SortOrder.Descending);

Chart_1.rankBy("NotSureWhatToPutHere");

I guess these are quite new functionalities and it seems they are not yet included in the new edition of the Developer handbook.

Thanks.

BR

Peter

Accepted Solutions (1)

Accepted Solutions (1)

avsalynin
Active Contributor

sanpe

link

tenants' fast track will probably be available earlier than at the end of the year;)

Answers (3)

Answers (3)

rk25350
Discoverer

Please follow the below for rankBy..

Chart_1.rankBy({

rankOrder:RankOrder.Top,

structureMember:"structure based on which rank will be done",

value:5});

}

avsalynin
Active Contributor

sanpe

based on what's noted here this will only work in optimized mode:

but for analytical applications this mode is not yet available (there is only for stories), so we expect it in the next releases of this year

p.s. added Api outstripped optimization mode:)

sanpe
Explorer

Hi Aleksey,

yep, I was searching for the optimized format option in the settings and indeed couldn't find it.

In any case it's interesting, that these are are already available in the menu, but not yet functional...

JBARLOW
Contributor
0 Kudos

Rankby etc works with Charts - but only if your Analytic App is set to use Optimised view mode at runtime.

However as always with SAP 🙂 there's a downside........ An App using optimised view mode against a live BW connection won't render charts (amongst other things)


Bug or To be implemented feature....... or misaligned product dev teams..................