Rank with Ties
I'm working with "Top 5" and in our data, the 5th place item actually has 5 rows with the same rank. In the widget, it just displays 5 items in total, leaving the other 5th place item's off the pivot. Has anyone been able to implement a "with ties" so that I can see all of them?
Data:
Site Aggregation Error 7
Balance Issue 6
No Action 5
Unconfirmed Files 2
Account Options 2
BAA Linking RQST 2
Edit Existing 2
Request to Add Account 2
Dashboard output:
Top 5 Case Types # Cases
Site Aggregation Error 7
Balance Issue 6
No Action 5
Edit Existing 2
Request to Add Account 2
-
Hey Malinda,
In your RANK function, you can specify whether ASC/DESC as well as the type of ranking (handling ties). So you can create a metric which is your RANKing, and clearly specify the different types:
EXAMPLE: RANK(SUM([Revenue]), "DESC", "1224")
The options are "1234", "1224", "1334", "1223".
Let me know if that makes sense.
Best, Elliott
-
Hi
I am trying to use RANK in a multi-pass scenario but having no success, could anyone help please?
Basically I have a Pivot with Rows='GroupName' and Values='Denominator'. I have to add column2 to pivot that shows the average of the Top 10 lowest Denominator values in column1. With the formula shown below I am getting an average of all the Denominator values , not just the top 10 in ASC.
Raking rule : same rank for duplicate Denominators, and no skipping .
Thank you
AY
Please sign in to leave a comment.
Comments
2 comments