Top 20 countries by the number of constituents

Lena Payne

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!

JoAnn Strommen

@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.

Ryan Hyde

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.