Sorting and Ranking Types
| Type | Description | Examples |
|---|---|---|
| Sorting | Order results by numeric values, text fields, or dates | • “Sort by revenue descending” • “Sort by date, newest first” • “Sort by region, then revenue” |
| Ranking | Identify best or worst performers. Can be applied globally or per group (e.g., per region or category). | • “Top 10 customers by revenue” • “Lowest-performing products” • “Top salesperson per region” |
| Percentile Ranking | Use percentiles to understand relative position. Useful for segmentation, performance benchmarking, and outlier detection. | • “Top 10% of customers” • “Bottom 25% by engagement” • “Customer lifetime value percentile” |