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

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 28

changes.mady.by.user user-3484a

Saved on

compared with

New Version 29

changes.mady.by.user Wendy R

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated for 9.3 release.

...

Overview


Styleclass
ClasstopLink

top37061203

You can set the default format for a field on the format tab. This will then be the display type when a user adds the column to a report. The report writer may choose to change the format through the report formatting options if they wish.

...

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 Format Options 37061203 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

This toggles the visibility of the

defaulted

thousand separator

for your instance on or off

. For example

: 1000 to

, '1,000' or '1000'. Note that it's possible to display different separators for users of different languages within your instance. See Configuration for more information.

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.

...

horizontalrule

Styleclass
ClasstopLink

top37061203