Title: County Counts
Last modified: October 20, 2022
---
# County Counts
* Resolved [GeraldRezes](https://wordpress.org/support/users/geraldrezes/)
* (@geraldrezes)
* [3 years, 7 months ago](https://wordpress.org/support/topic/county-counts/)
* Is there a way to display a count of users from each country when the COUNTRY
metadata field is used? Example, Brazil: 8, Cuba: 3, United States of America:
34, etc. Even if I had to filter by Country, I could figure out how to setup
the page. TY
- This topic was modified 3 years, 7 months ago by [GeraldRezes](https://wordpress.org/support/users/geraldrezes/).
Viewing 8 replies - 1 through 8 (of 8 total)
* Plugin Support [andrewshu](https://wordpress.org/support/users/andrewshu/)
* (@andrewshu)
* [3 years, 7 months ago](https://wordpress.org/support/topic/county-counts/#post-16121422)
* Hello [@geraldrezes](https://wordpress.org/support/users/geraldrezes/),
* There is no such function.
You could try a direct database query.
* Thank you.
* [missveronica](https://wordpress.org/support/users/missveronicatv/)
* (@missveronicatv)
* [3 years, 7 months ago](https://wordpress.org/support/topic/county-counts/#post-16124186)
* [@geraldrezes](https://wordpress.org/support/users/geraldrezes/)
* You can try this code snippet and use the shortcode:
`[count_users_custom meta_key
="country"]` or any other meta_key.
* Install the code snippet into your active theme’s functions.php file
or use
the “Code Snippets” plugin.
* [https://wordpress.org/plugins/code-snippets/](https://wordpress.org/plugins/code-snippets/)
* ```
add_shortcode( 'count_users_custom', 'count_users_custom_shortcode' );
function count_users_custom_shortcode( $atts ) {
global $wpdb;
if( empty( $atts['meta_key'] )) return 'No meta_key';
$meta_key = sanitize_text_field( $atts['meta_key'] );
$users = $wpdb->get_col( "
SELECT meta_value
FROM {$wpdb->usermeta}
INNER JOIN {$wpdb->users} ON user_id = ID
WHERE meta_key = '{$meta_key}'" );
$options = array( 'empty' => 0 );
foreach ( $users as $value ) {
if( !empty( $value ) ) {
if( isset( $options[$value] )) $options[$value]++;
else $options[$value] = 1;
} else $options['empty']++;
}
ob_start();
echo 'Total number of users found: ' . count( $users ) . '
';
foreach( $options as $key => $count ) {
echo '';
echo '
' . $key . '
';
echo '
' . $count . '
';
echo '