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

Versions Compared

Key

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

...

  1. Open the field's drop down menu, in either of these locations:
    1. Through the Columns/Rows list
    2. Through the Table Preview
  2. Now select Select the Advanced Function option from the list, opening then select Edit to open the Advanced Function display.
  3. You will now need to complete the function options:

    1. Apply the appropriate aggregation to the field. This ensures the function is applied on top of any aggregations necessary.
    2. Select which function type you wish to use, from Analysis, Statistical, and Text.
    3. Select the name of the function you wish to use from the list. Once selected, you will see a description of the function displayed next to it. Some functions require extra parameters, which will need to be defined once the function has been selected.
    4. You also have the option to set the function to only display on the Charts page. This hides the field on the report table, but you will still be able to see and edit it through the Column/Rows list. This allows you to create additional copies of a field to apply functions for graphical purposes, without cluttering your table with extra fields.
  4. When defined, click Save to apply the function.

...