Assigns a quartile by rank within a sorted list (NTILE(4)).
Rank 1 is the largest/first contributor. With this convention quartile 1 is the top quarter of the list.
1
1-based position in the sorted list.
Total number of contributors.
The quartile 1–4.
4
quartileByRank(1, 100); // 1quartileByRank(60, 100); // 3 Copy
quartileByRank(1, 100); // 1quartileByRank(60, 100); // 3
Assigns a quartile by rank within a sorted list (NTILE(4)).
Rank
1is the largest/first contributor. With this convention quartile1is the top quarter of the list.