Database ranking is an advanced query filter that can rank the query results according to a measure.
Ranking is good for classical business questions such as the following:
Who are the top n customers by revenue?
What are the top n most sold products?
Which sales people had the least n sales?
First, we will build our query by dragging-and-dropping the Sales Person and Sales Revenue objects. We will mark the Sales Person dimension objects and click on the Add a database ranking button located on the query filter's top right-hand side, as shown in the following screenshot:
In the database ranking created filter, we will notice the following options:
The ranking can be adjusted to Top, Bottom, % Top, % Bottom (that is, from the number of records):
The default ranking number is 10, but it can be adjusted to any other number too as it can be changed into a Prompt, as shown:
The...