Top 20 countries by the number of constituents

Lena Payne
Lena Payne
First Reply Kudos 1 Name Dropper First Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussions

Hello, I am just wondering how you would go about finding out the top 20 countries that your constituents live in and how many constituents we have per each of the 20 countries? Thank you!

Comments

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 January 2026 Monthly Challenge 2025 bbcon Attendee Badge

    @Lena Payne I haven't done by country but have filtered by state. See if in db view Reports > Demographic and Statistical Reports > Statistical Reports might work. Filter by Country.

    18796288278299e3bd2be7d59a072c54-huge-im
  • Ryan Hyde
    Ryan Hyde
    Second Anniversary First Reply Name Dropper Kudos 1

    I would personally run a query that includes all constituents, then output the preferred address > country of each record (technically you should do this via export, but so long as you're only using the preferred address section in query, you shouldn't get any duplicate rows). Then I would just do a pivot table to get counts by country.

    I find this sort of methodology a lot easier than remembering which reports do what.

Categories