Ability to Filter based on Rank (e.g. Find the Top 5/Bottom 10)

A similar request to https://support.ninjacat.io/hc/en-us/community/posts/360017750752-Abilty-to-double-sort-using-2-metrics

Filter based on the rank of a metric, so we can have Top/Bottom N of any metric. The challenge is that this would need to be independent of any sorting.

AdWords Example:

Top 10 Campaigns based on clicks, and then sort by CTR.

Currently, the best you can do is create a 'hidden Column' which is a custom (decimal) metric.
Calculation = clicks  + (CTR/1000)
This still leaves you with Campaigns sorted by Clicks, and for identical Click counts, it sorts by CTR.


1 comment

Please sign in to leave a comment.