Using the maps provided in Xcelsius/Dashboards 4.x is not difficult, but I have often seen developers forget how to set them up properly to get them to display the data and alerts because it is not the most obvious/intuitive component and also not frequently used.
I finally made this cheat sheet to help them remember how to set it up.
1) The Display data must be 2 columns – your labels column AND values:
The Region Keys (labels) will be the state names or abbreviation, whichever you have chosen, and the Display Data will be the values that are shown when the user hovers over and selects that state.
2) You must include all 50 states PLUS the District of Columbia (DC), even if you do not have data for each state. If you leave one out, then the state names will not match properly. (This is for the USA map. If you use the USA Continental map, then Hawaii and Alaska are excluded).
3) Your Alert values must also be 2 columns – your labels column and your alert values
4) You can use either long state names or abbreviated names, but you must be consistent. You cannot use long state names in your labels, and then reference the short names in the setup of display data or alert values.
And that’s it – the quick and easy map setup & alerting!
For more advanced map options, check out the CMaps Plugin as used in this award-winning dashboard designed by InfoSol.
For more information about the CMaps Plugin or for assistance in designing advanced dashboard solutions you can contact us.
If you want more map options and anything “outside the box”, I recommend visiting our partner at Centigon Solutions and check out their CMaps Plugins and cool location intelligence offerings.
Happy Dashboarding!