ArcGIS Maps for Office - Aggregate by Counties

[Anonymous User]

I am trying to introduce some people to ArcGIS Maps for Office. When playing around with some test data, I noticed I was unable to aggregate my data by county, I am however able to aggregate the data by zip,state, and etc. Am I missing something there or did that data need to be transformed before hand before one computes it at the county level?

 Example Columns:

Location Name

Location Description

City

State

County

Zip

Total_Collection

Latitude

Longitude

Dates Available

[ShannonChavez]

Hi Kyle, 

Thank you for your inquiry. I was able to aggregate counties but my guess is, I was able to accomplish this by adding data using Cell Range. See the steps below and the sample data I used!

1. Open excel & sign in

2. Add Map (Add data from Excel using the Data format Cell Range as default)

3. Click Select range

4. Highlight the selected data range

5. Location Type is States

6. Select Map Style by column

7. (I selected) Column B

8. Select Add data

OBJECTID	Counties	States	STATE_FIPS	CNTY_FIPS	FIPS	AREA	POP1990	POP2000	POP90_SQMI	Shape_Length	Shape_Area
1	Lake of the Woods	Minnesota	27	077	27077	1784.063	4076	4651	2	4.05546	0.56545
2	Ferry	Washington	53	019	53019	2280.232	6295	7199	3	3.786161	0.718059
3	Stevens	Washington	53	065	53065	2529.979	30948	40652	12	4.876296	0.795486
4	Okanogan	Washington	53	047	53047	5306.18	33350	38640	6	6.673169	1.66911
5	Pend Oreille	Washington	53	051	53051	1445.029	8915	11752	6	3.101655	0.455726
6	Boundary	Idaho	16	021	16021	1279.299	8332	10068	7	2.943635	0.404983
7	Lincoln	Montana	30	053	30053	3746.091	17481	18859	5	5.308776	1.180135
8	Flathead	Montana	30	029	30029	5232.031	59218	73438	11	7.973459	1.642156
9	Glacier	Montana	30	035	30035	3124.457	12121	12626	4	5.221489	0.985039
10	Toole	Montana	30	101	30101	1943.26	5046	4556	3	3.356589	0.613868
11	Liberty	Montana	30	051	30051	1485.946	2295	2222	2	3.071839	0.468896
12	Hill	Montana	30	041	30041	2917.361	17654	16862	6	4.545181	0.920879
13	Sheridan	Montana	30	091	30091	1686.583	4732	4006	3	3.213947	0.533393

Please let me know if this was helpful!

Best, 

Shannon | Product Engineer

[Anonymous User]

Thank you for the response.

I have been able to achieve what you have shown above, but I am trying to do it at the county level within a single state.

Example:

Location Name	Location Description	County	State	Total_Collection	Dates Available
Site 1	203 East US Highway 18	Bennett	South Dakota	62	Nov. 16 - Dec. 1
Site 2	Junction of US Hwy 85 and US Hwy 212	Butte	South Dakota	63	Nov. 16 - Dec. 1
Site 3	801 1st Ave. E	Clark	South Dakota	10	Nov. 23 - Dec. 8
Site 4	99 S. Commercial St.	Clark	South Dakota	22	Nov. 23 - Dec. 8
Site 5	710 SD Hwy 28	Clark	South Dakota	5	Nov. 23 - Dec. 8

Where with the above data I would be trying show the total collection for each county. Bennett would be 62, Butte 63, and Clark if sum aggregated it would be 37. Like I mentioned before I am able to get that function to work with every other location type, just not counties.  

As you can see below, it will just stack the counties with out aggregating them. 

The option below I am looking for; shown with zip code:

Thanks, 

Kyle

[ShannonChavez · Accepted solution]

Thank you Kyle, appears as if this may be a bug. I have reported this to our team and we will be investigating further. 

[Anonymous User]

Thank you for your assistance.