Skip to main content
Adaptive Planning
Last Updated: 2023-06-23
Reference: Geo Map Settings

Reference: Geo Map Settings

Geo maps are geographic charts that visualize data with circles based on geographical locations.

Appearance Settings

Section
Field
Considerations
General
Name
Enter the chart title.
Character Limit: 50
General
Show In Presentation Mode
We select this option by default to display the chart in presentation mode. Turn the toggle off to hide the chart in presentation mode.
Conditional Formatting
Add Rule
Add conditional formatting rules.

Data Settings

Section
Field
Consideration
Accounts
[Account Name]
Expand the Accounts section to view, change, delete, or add accounts to the chart. Each account represents a data series on the chart.
Each account in a chart has its own settings:
  • Expand to change the settings for the data series.
  • To remove an account from the chart, select
    Delete
    from the related actions menu of the account.
  • To reorder accounts, drag and drop the the handler icon. The order affects the format and placement of the data series in a chart.
  • Add
    to add accounts or dashboard metrics to the chart.
Accounts
Name
Sets the display name of the data series. Character limit: 50 characters. When you edit the name for these charts, you remove the version from the chart axis label:
  • Area.
  • Bar.
  • Column.
  • Doughnut.
  • Funnel.
  • Line.
  • Pie.
  • Pyramid.
Example: The default name for the data series is 6200 Taxes & Benefits (budget version). You edit the name to Taxes & Benefits. We no longer display the version label (budget version) on the chart, even when you reset the name back to the default.
Accounts
Account
Changes the account in the chart.
Accounts
Version
Changes the version for the data series. Select
From version selector
to use the version currently selected on the toolbar. Example: Add a data series twice to a chart and change the versions for each to compare data between the 2 versions.
Accounts
Filter
Filters the data by levels, level attributes, custom dimensions, and dimension attributes.
Accounts
Display Values By
Display values by circle size or color scale.
Accounts
Color
Indicates the color for the data series. The color next to the account settings section represents the color for the data series.
When you select
2-Color Scale
, you can indicate a
Minimum
and
Maximum
color for the data series.
Accounts
Overlay By Size
You can overlay two accounts to visualize both size and color scale on a single series.
Accounts
Display Units
Format the display units:
  • Follow Account
    : Use the display units set from the account. We use this format by default.
  • #,000,000 (#,##0.#)
    : Display as millions with 1 decimal.
  • # (#,##0)
    : Display as thousands with no decimals.
  • #,000 (#,##0.#)
    : Display as thousands with 1 decimal.
Accounts
Negative Number Format
Format the display units for negative numbers:
  • -123,456,789.12
    : Use a negative sign to indicate a negative value.
  • (123,456,789.12)
    : Enclose a negative value in parentheses.
Accounts
Geo Dimension
Geo maps require a custom dimension with latitude and longitude coordinates.
Accounts
Dimension
Lists associated dimensions for the account used on the model sheet. The dimension must have custom properties with latitude and longitude coordinates. Pin a specific hierarchical dimension value to always display the child regions.
Accounts
Latitude Property
Lists all custom properties for the dimension. Provides the latitude coordinate for data points.
Accounts
Longitude Property
Lists all custom properties for the dimension. Provides the longitude coordinate for data points.
Accounts
Add
Select
Add
to add accounts or dashboard metrics to the chart.
Breakdown
Type
Settings that determine how to break data into granular groups.
Possible values:
  • Time: Breaks down data by time as defined by the time settings. Example: Break down data by each month in a year or by quarters.
  • Dimension: Breaks down data by a dimension, including levels and attributes. When you select this option, you must select a dimension. Example: Break down data by a level, location, or product.
  • None (default).
Breakdown
Dimension
Specifies the dimension when the breakdown is Dimension.
Breakdown
Sorting & Limits
Expand this section to define how to sort and limit data on a map.
You can't sort and limit when a Breakdown is selected.
Breakdown
Sort By
Specifies the element to sort by.
  • None (default)
  • Data Series: Based on accounts or calculations added as data series to the map.
Breakdown
Limits
Indicates how to limit the data that displays in the chart.
  • Show all records (default):
  • First N
  • Last N
  • First % N
  • Last % N
When you select any First or Last option, enter a numeric value to indicate the number or percentage to limit by. Example: If  you choose Last N and enter 10, the chart will display the last 10 records on the Sort By and Sort Order selections. If you choose First % N and enter 10, the chart will display the first 10% records based on the Sort By and Sort Order selections. If the record set is 100, the chart displays the first 10 records.

Time Settings

Section
Field
Considerations
General
Calendar
Displays when your instance uses alternate calendars. Select the calendar to use.
General
Stratum
Select the time strata for the data set.
General
Span
  • Range
    : Select to display data for a specified range of periods. You can select the start and end of the range for pinned charts, or set the start and end offset for unpinned charts.
  • Single Period
    : Select to display data for an entire period or all dates up to a date. You can select the start and end of the range for pinned charts, or set the start and end offset for unpinned charts.
General
Data Range
Displays when you select
Single Period
for
Span
:
  • Total Period
    : Includes all the dates in a period.
  • To Date
    : Includes all dates up to a specific date.
General
Pin and Unpin Time
Sets time on the chart as pinned or unpinned:
Blue pinPin (blue) to set a fixed time period. The period of time for pinned charts is based on the selected strata. For example, if you select the strata:
  • Month: Choose periods based on month-year.
  • Quarter: Choose periods based on quarter-year.
  • Year: Choose periods based on the year.
For Single Period spans, set a specific date, such as May 2017. For Range spans, select the start and end dates, such as May 2017 to June 2017.
Grey pinUnpin (gray) to set time relative to the reference period displayed on the perspective toolbar. Relative time is based on the selected strata. Select:
  • Current: Matches the current reference date.
  • Backwards: Adjusts backward by the number you enter.
  • Forwards: Adjusts forward by the number you enter.
For Single Period time spans, set the relative time for the chart. For Range time spans, set the relative time for the start and end of the range.