Ranking range [Windows] [Linux]
Often, we want to analyze our data by focusing on top or bottom performers, and for that, Sisense provides convenient out-of-the-box ranking filters. However, there are times when the analysis requires a bit more nuance—for example, looking at results that fall within a specific ranking range, such as positions 5–10 or 11–50. In these cases, the standard top/bottom filters alone aren’t enough to meet the need.
Step-by-Step Guide
In this example, we'd like to focus our attention on our product categories ranking 4-6 to see how to improve our medium-selling items.
For this, we'll use a combination of the RANK() function (Documentation) and then determine which ranking indexes we'd like to display.
The second argument determines the sort order: "ASC" or "DESC". In our case, we’ll use "DESC", which ranks the categories from highest to lowest.
This will generate the ranking index for each category based on the chosen measure.
- Start with a pivot table. Regardless of the final widget you want to use, begin with a pivot table so you can see all the categories and the underlying data.
- Add the RANK() function. The first argument of the RANK() function should be the measure you want to rank by—in this example, SUM([REVENUE]).
- Next, add a filter by value on the newly created RANK field. Set the range you’d like to display—for example, rankings 4 through 6.
Conclusion
That’s it! You’ll now be able to display only the specific ranking range you need. If you prefer, you can even toggle off the RANK function so it doesn’t appear in the widget, while the filter still applies in the background.
Published 10-09-2025
