Using Latitude and Longitude in Geomaps

If you have latitude and longitude data that you want to use in Geomaps, you can create a custom GeoAttribute for it.

For example, you have two attributes, one with latitude data and one with longitude. You create a custom attribute based on an expression that concatenates the data. The new attribute can be used with a Geomap to precisely locate an entity, such as a store and warehouse.

The built-in Visualizer Geomaps support this syntax for latitude and longitude:

(LatitudeAttribute, LongitudeAttribute)

If you have an attribute that is already in this format, you can use it with a built-in map. If you have separate attributes, use the Expression Builder to concatenate them.

To create a custom GeoAttribute for latitude/longitude, complete these steps:

  1. In Visualizer, click Expression Editor (the brackets icon).
  2. In the Expression Builder editor, name it and click the Attribute option.
  3. Specify the expression to concatenate the base attributes. For example, in Basic mode:

    In Advanced mode: (((('(' + [Retail_Stores.Store Latitude]) + ',') + [Retail_Stores.Store Longitude]) + ')')
  4. Click Save. The expression is listed in the Attributes list.

  5. Use the new expression as the GeoAttribute. For example, on a bubble map.

  6. Alternatively, you could choose a marker layer type.

In a marker-style map, do not display latitude and longitude in the tooltip. Instead, display a descriptive value, such as the location name or store name.

To change the display tooltip for a marker, complete these steps:

  1. In the Subject Area Attributes list, select the expression and click Edit.

  2. In the Expression Builder, add the Store_Name attribute and a pipe. The pipe will substitute the value of Store_Name in the tooltip. For example in Basic mode:

    or in Advanced mode: ((((([Retail_Stores.Store_Name] + '|(' + [Retail_Stores.Store Latitude]) + ',') + [Retail_Stores.Store Longitude]) + ')'))
  3. Save the expression, or save it under a different name.
  4. Add it as a GeoAttribute in the Chart Builder. The expression evaluates as the Store Name in the tooltip.