Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.
Sign up to join this community
We are building a family community website with more than 600 members all over the world.
In craft.users we have added many fields and one of them is country.
We want to display and count all countries.
Example of the desired output could be something like:
Our members are living in the next 5 countries
Something like this should do the trick:
{% set usersGroupedByCountry = craft.users.limit(null)|group('postaddress.country') %}
<ul>
{% for country, users in usersGroupedByCountry %}
{% if country and users|length %}
<li>{{ country }} ({{ users|length }})</li>
{% endif %}
{% endfor %}
</ul>
Note that if you want to order the list of countries, you'll need the SuperSort plugin. Here's how you would sort the list alphabetically:
{% set usersGroupedByCountry = craft.users.limit(null)|group('postaddress.country)|supersort('ksort') %}
Also note that if you have a lot of users (say, hundreds), it is probably a good idea to wrap the whole thing (including the {% set usersGroupedByCountry ... %} part) in a {% cache %} tag pair, for performance reasons.
countryfield on your Users field layout? If so, what type of field is it? – Brad Bell Sep 28 '16 at 21:53