Top 20 countries by the number of constituents

Lena Payne
Lena Payne
Kudos 2 Second Anniversary First Reply Name Dropper
in Raiser's Edge NXT 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 July 2026 Monthly Challenge bbcon Sessions March 2026 Challenge: Answered Questions

    @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