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

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 4

changes.mady.by.user Yellowfin

Saved on

compared with

New Version 5

changes.mady.by.user Yellowfin

Saved on

Key

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

...

You can create a number of different types of calculated columns including:

by writing the SQL using

Type

Description

Formula BuilderSimple Formulas

This allows you to build calculations through a builder interface, rather than having to write the SQL yourself.Freehand SQL

Pre-Defined

This allows you to build a calculation using a template, rather than having to use a builder, simply by specifying the fields it requires.

Formula Templates (Custom Functions)Freehand SQL

This allows you to build a calculation using a templateby writing the SQL, rather than having to use using a builder, simply by specifying the fields it requires.

...



Simple

Styleclass
ClasstopLink

top

The formula builder assists you to write valid formulas for your view. Calculated fields written in this way can be used as normal fields within a report – i.e. all functions can be applied to them such as aggregations etc. This is not possible with SQL calculated fields. To begin you will need to work out what type of field your resulting value will require and select either Metric or Dimension.

...