Qrew LegendOK, I'll take Map Brainteasers for $1,000.
I did a bit of a test and this approach shows promise. If you map an Address in US format with just the State, then it plunks the pin down somewhere in the middle of the state.
So, ..... if you create an [Address State Only] field and use a Pipeline to populate only the state, then you could run a Maps report based on that [Address State Only] address. The pin will show a count because all of the addresses in that state are at the "same" address.
Alternatively, I suppose that you could choose a city or perhaps the capital city of every state and contrive a pipeline to populate a mirror field with that exact address of the state capital legislature building. Maybe have a look at every state and find the little hick town that seems to be most in the geographic middle of the state.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
