August 7, 200718 yr Newbies I have a summary feild that totals for each county in a state. I would like to display this data on a state map with each county total displayed in the county on the map. Is there a way to do this? I have looked around but have not seen anything. Thanks.
August 7, 200718 yr Well, you could paste a map onto a layout then put calculated totals onto all of the counties.
August 7, 200718 yr Author Newbies That is the direction I was thinking, but I have summary fields that total the county numbers.
August 7, 200718 yr Create a table for Counties, with a relationship to the number data table. Create a calculation field: Sum ( relationship::number ) That gets you the count per county in a field in its record. But to put it arbitrarily on a map, you need more flexibility. You could use a Cartesian relationship (X). That would get you all the counties, each in a row of a portal. Then, using 1 row portals, you can put a portal with only row 1 wherever, then a portal with only row 2, etc.. They would all have the same count field inside.
March 23, 201015 yr anyone know of where I can find a template that has a U.S. map that can display one data point in each state?
Create an account or sign in to comment