Configure Data for Geo Charts (pushpins)

Prepare data

To use geo charts in Analytical Designer, you must include the geographical information in the data that you add to your dataset.

The pushpin information must be in the following text format:

<latitude>;<longitude>

Follow these rules:

  • Separate the values by a semicolon (;).
  • Do not include spaces.
  • For latitude, use positive values for the Northern hemisphere, and use negative values for the Southern hemisphere.
  • For longitude, use positive values for the Eastern hemisphere, and use negative values for the Western hemisphere.

Example:

37.755919;-122.477711
37.492912;-121.992132

Add a Label to the Regional Attribute

After you add the geo data to your data model, add a label to the attribute. The label connects the attribute and geo charts.

Steps:

  1. In your GoodData Portal, switch to the Data tab.
  2. Click Model on the top. The current project logical data model opens.
  3. Click Edit.
  4. Select the dataset that the attribute belongs to and click More… → View details. The dataset details dialog opens that lists all the dataset facts and attributes.
  5. Select the attribute, and click Add label.
  6. Type the label name, and click Save changes. The dialog close and the label is added to the attribute.
  7. Click Publish.
  8. Select Preserve data and click Publish.

The publishing process starts. When the publishing completes, you see a message that the LDM has been published. Close this message.

Set a Geo Type for the Attribute Label

After you add the label to the geo attribute, modify the type of the label to match the geo type of your data. The attribute is then available in geo charts.

Steps:

  1. Log in to the GoodData Portal.
  2. On the Manage page, click Attributes.
  3. Select the geo attribute. The attribute information page opens.
  4. In the Labels section, click Edit for the label that you added. Label information opens for editing. 
  5. In the Type dropdown, select Geo pushpin
  6. Click Save.

You are now ready to create geo chart widgets on your dashboards.