Skip to Content
Author's profile photo Krishnaprasad MT

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.

 

 

/wp-content/uploads/2016/03/1_904856.png

/wp-content/uploads/2016/03/2_904857.png

After Ranking there are 11 records displayed in the table , but  our  requirement is to have only  10 records.

 

 

/wp-content/uploads/2016/03/3_904858.png

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.

 

 

/wp-content/uploads/2016/03/4_904860.png

In the Webi report looks as below

 

 

 

/wp-content/uploads/2016/03/5_904861.png

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.

 

/wp-content/uploads/2016/03/6_904863.png

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.

 

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.