Like what you see? Have a play with our trial version.

Versions Compared

Old Version 19

changes.mady.by.user user-3484a

Saved on

compared with

New Version 20

changes.mady.by.user user-3484a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

OptionDescription
Geometry FormatThis allows you to specify the format of your native geometry field, define the order of lat and lon values in each point.
Cache FieldThis allows you to select which field to cache the geometry data against.
Format

Each data type will have a unique set of format options – eg Text, Date or Numeric.

See 20709721 Format Options below for details on each type.

Decimal Places

If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in: 2
Note: To convert numeric data by doing divide by 1,000 calculations etc you would use the data conversion options in advanced functions which are available on the Report Fields page.

See Advanced Functions for more information.

PrefixThe prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $
SuffixThe suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: %
Rounding

This allows you to define how the value of the field should be rounded. The following options are available:

    • Round Up - Will round any decimal up e.g. 1.1 to 2
    • Round Down - Will round any decimal down e.g. 1.9 to 1
    • Round Half Up - Rounds 0.5 and above up
    • Round Half Down - Rounds 0.5 and below down

Thousand Separator

Turns the defaulted thousand separator for your instance on or off. For example: 1000 to 1,000
Bracket NegativesThis allows you to wrap negative values in brackets.
Default Aggregation

When the field type is a metric you will be able to set the default aggregation (e.g. Sum, Average etc).

This is used when adding the metric to a report it will automatically set the aggregation based on this default value.

The options in the dropdown when the field type is a date are count, max and min. For all other field types the dropdown options are sum, average, count, max and min.

See Aggregation for more information.

Colour

When the field type is a metric you will be able to define a default colour to be applied in charts.

See Chart Formatting for more information on how to use Colour Sets.

Chart GranularityDefines the default unit applied to this field when used in a time series chart.
Filter Value CaseThis allows you to specify if user prompt filter values entered by a user are converted automatically to upper or lowercase before being applied.

...