I am trying to create a mapping path that shows enrollment migration similar to this: American Migration [Interactive Map] - Forbes. While I can get the map to display the path, I can't seem to figure out how to change the color of the path based on the difference. For example, if more students leave than enroll then this negative impact would be a red line and if more students enroll than leave that this positive impact would be a blue or green line.
Hi Barbara,
You need to have a field that enumerates the color range for the negative/positive impacts. One way to do this is as below.
Assuming that [Loss/Gain] is the field to be used to calculate this:
1) Create a calculated field to sum up [Loss/Gain] using the WINDOW_SUM and SUM functions - ([Loss/Gain Path])
2) Create another calculated field using the SIGN function to enumerate whether the above value is negative/positive - ([Loss/Gain Path Sign])
3) Drag the above field to the color shelf;
Right click the field on the shelf and edit the table calculation
Select 'Advanced' in the Compute Using drop down
Move all other fields except for Path ID out of the Partitioning box, into the Addressing box
Finally, set the field on the shelf to be Discrete, then edit the colors in the legend as required.
See Sheet 2 in the attached workbook
(Note: you could combine steps 1 & 2 together to just have the single sign field, but it helps to have the first one as a separate field for validation e.g. you could add it to the tooltip)
Hope this helps.
Regards,
Tram.
