Below is the screenshot and the Publish to Web link for my first go at the Enterprise DNA member location report. Thanks to everyone who entered your location info - the mapping and analysis definitely gets more interesting the more members we have in the dataset. If you haven’t entered you info, but would like to you can do so via the red button at the bottom of the report, or by going to the entry form directly by clicking here.
(1/5/21 update - Thanks to those who responded previously. Entry in this form is no longer needed, as I now receive a weekly data download of all membership information from the Enterprise DNA team.)
While this report looks pretty simple, there is some more complicated stuff going on under the hood, including reverse geocoding scripts, fairly extensive PQ/M data cleaning, use of nonprinting characters to correct ranking of cities with the same name in different countries, filtering the date slicer by active dates, etc. I will be writing this up over the weekend as I would a Data Challenge entry for anyone interested in how I put this report together.
Finally, two shout outs - the first to @Despo for coming up with the idea to do this in the first place, and the second to Karen Sangil, eDNA’s outstanding graphic designer who did the templates for Problem of the Week, which I also used as the basis for the design and color scheme on this report.