Defining SQL expressions for a report

When you add a column to a report in the Report Editor, you can specify that you want to use an SQL function. The Calculation Builder provides a guided interface to help you define SQL expressions for use in reports.

  1. In the Report Editor, click +Column in the Columns section.
  2. Click Calculations, and select the SQL function that you want to use. The Calculation Builder opens and displays a description of the function and its use.
  3. In the Function input section, define the SQL expression. Use the down arrow to display either a subset of options that are likely to have the parameter you are looking for, or all parameters.

    You can build nested expressions by using an SQL function as the parameter value for another SQL function.

  4. Click Submit to apply your changes.