Skip to main content

Varicent ELT Help Center

Map

Use a Chart map to show spatial data that shows location. To create a map, your data set must include some geographical data, such as

Map.svg

Input

The Map chart requires some geographical data in your data set, and requires both numeric and text columns.

Configuration

Use the following configuration options to configure the Map chart.

Note

The Configuring the Map chart gives configuration options through the Pipe module. If you have already created charts, you can access them through your Dashboards.

Configuring the Map chart

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least two data sources to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Add tools to build out your pipe. For more information about adding tools to your pipe, see the Using the Pipe builder canvas documentation.

  5. Create a chart from your pipe by clicking Charts on the canvas toolbar.

  6. Click Create Chart.

    The chart page opens.

  7. From the configuration pane, go to the Setup tab, and select the tool that you want to create a chart for.

    Note

    Whatever tool you select in your pipe when you add the chart is selected by default.

  8. Under Chart type, start typing Map to filter the list, then click the Map graphic to select it.

  9. Under Map, select the type of map to use in the chart, World, USA, or Canada.

  10. Under Location, select the column to chart the location.

  11. Under Value, select the numeric column for the location values.

  12. Expand the Advanced field, click Show to select either Preview or Last built:

    • Preview displays the first 100 rows of your data from your last build.

    • Last build displays the first 1000 rows of your entire dataset from your last build.

  13. Under Sort, select to sort your chart data by None, Ascending or Descending.

  14. Click Aggregate? to aggregate your chart data.

  15. Under All, select the operation to calculate your columns with:

    • Sum

    • Count

    • Average

    • Max

    • Min

    • Median

    • OR

    • AND

    • STDEV

  16. Under Gender ID, calculate the gender columns that you select with one of the following operations:

    • Sum

    • Count

    • Average

    • Max

    • Min

    • Median

    • OR

    • AND

    • STDEV

  17. Click the Customize tab to add custom styling to your chart.

    Table 120. Customize tab configurations

    Field

    Description

    Chart and axis titles

    Select the following to add titles to your charts. To update the title from "Untitled" to something meaningful, click on the title to edit.

    • Include chart title

    • Include chart subtitle

    Colour

    Expand the Colour field, click on the column colour, and select a new colour.



  18. Click Return to pipe to go back to your pipe. To view your chart or create a dashboard for your charts, read the Dashboards documentation.