Alternate Method for Ranking.
This document will explain a scenario where we need to use an Alternate Method instead of Ranking.
We have a scenario to create a report for top 10 active users having the highest value for count( Event id) .
Here we need ONLY TOP 10 users & only 10 records to be displayed in my report.
So if we tried to create a RANK as in the below screenshot.
After Ranking there are 11 records displayed in the table , but our requirement is to have only 10 records.
There are 11 records , as you can see in the above screenshot that there 5 records having the same rank. And there by causing 11 records.
Here use of RANKING is not helping.
In order to achieve my requirement , have to use Row number function .
1. Create an object as per below definition.
In the Webi report looks as below
You can see in the above screenshot that even though rank is same they are having different row number.
Also row number is created in the descending order based on the Count of Event id .
2. Now filter this table using Rownumber object as shown below.
3. Now we have TOP 10 users with & only 10 records to be displayed in the report.
Hope this document will help some of you.