Donor Ranking in RE and In General
I have a question regarding Top Donor Reports. I've been working in non-profits for nearly 16 years. I also have a background in research and science (Biology, Ecology, and Chemistry). A few days ago, my supervisor said I was ranking donors in our top donor report incorrectly.
Example: She stated that if someone has donated the same amount, they get assigned the same rank (I agree here), but that the next donor gets assigned NOT the next logical ranking number, but the number they would have gotten if the previous rank had not been adjusted. More specifically, if donors 3 and 4 donated the same amount, they both get assigned a rank of 3, but the next person (#5 originally), would not be assigned Rank #4, they would still be Rank #5. So, what would happen to Rank #4? Person #4 was assigned Rank #3 based on the amount donated, so they can't also be #4 - that would be a Count function. Why is rank #4 being skipped? Logically, that 5th person should get rank #4,as a result of the previous ranking of #3, if ranking is truly based on the amount. It seems like a Count function is getting confused with rank by amount. Can someone clarify this? I'm truly baffled, as a logical person.
Comments
-
@Ally Nauer This is just a counting method. I've seen it a lot. It's so that you don't go over your number. In your example, there is no #4 because there are two #3s. The next rank is 5th, stating there are 4 entries ranked higher, not 4. Honestly, it's a preference issue, and probably not worth a lot of discussion. I'd direct you to this Wikipedia link for more information.
3 -
@Ally Nauer
It is a preference more than anything else, neither is right or wrong. Which is why, most product will support both. For example in one of the most popular SQL server, you can get Rank that does what your supervisor wants, or you can do Dense_Rank that does what you think is correct.https://learn.microsoft.com/en-us/sql/t-sql/functions/dense-rank-transact-sql?view=sql-server-ver16
3 -
@Alex Wong Ok. Thanks, that's good to know. See, if I were worried about going over, I'd do a separate column with the Count, but like you and Dariel have just replied, it's ultimately preference.
1 -
@Dariel Dixon Good to know. Appreciate the response. My brain was turning into the Anger emotion from Inside Out.
1
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 656 Blackbaud Grantmaking™
- 577 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 249 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 794 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

