Page History
...
Option | Description |
---|---|
Geometry Format | This allows you to specify the format of your native geometry field, define the order of lat and lon values in each point. |
Cache Field | This 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.
|
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
|
Prefix | The 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: $ |
Suffix | The 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:
|
Thousand Separator | Turns the defaulted thousand separator for your instance on or off. For example: 1000 to 1,000 |
Bracket Negatives | This 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.
|
Colour | When the field type is a metric you will be able to define a default colour to be applied in charts.
|
Chart Granularity | Defines the default unit applied to this field when used in a time series chart. |
Filter Value Case | This allows you to specify if user prompt filter values entered by a user are converted automatically to upper or lowercase before being applied. |
...