Hello all and thanks in advance.
I'm struggling to find a way to implement a Ranking view of a measure and a dimension. My requeriment is to show the top 10 in a Bar Chart but I have two problems:
1. How to filter the results to the top 10? I've trying a lot of different things like sorting the Datasource and save the top 10 in an array for later use this array to filter the datasource with the setFilter script function, but I cannot get the results I want. I'm working with a predefined view with HANA so it is not possible to alter the view, the Top has to be done in Design Studio.
2. If I get the top 10 results, how can I activate the scrollbar feature in the bar chart? I have height to only show 5 results but I would like the posibility to show the top 10 results. I have tried with the SDK components available here in the community but nothing fits exactly my requeriment.
I would like to obtain something like:
It is possible?