# Data explorer challenge: Generate list of members by location

**URL:** <https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [1월 12, 2017, 3:11오후 UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648 "2017-01-12T15:11:45Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![mikechristopher](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mikechristopher/32/89135_2.png) [@mikechristopher](https://meta.discourse.org/u/mikechristopher)\
**Post date:** [1월 12, 2017, 3:36오후 UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648/2 "2017-01-12T15:36:51Z")

</div>

The issue with the location field as it is is that is free text entry - so whilst some people could have put in Pakistan others could have just put in India for example. I would love to be able to use a localised mention system or at least some visibility on where members are from but whilst its free text and not validated or from a drop down its going to prove difficult.

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648)._