Using LQL to generate the Results Table results

By default, the Results Table component displays a list of records. You can also configure a Results Table component to display a set of metrics generated from an LQL query.

On the edit view of a Results Table component, to use an LQL query to generate the Results Table results:

  1. Under LQL Configuration, check the Use LQL query checkbox.

    The LQL query text area and Advanced LQL Options section are displayed.

    Results Table edit view - LQL option selected

  2. In the LQL query field, type the LQL query.
  3. After entering the query, to validate it, click Test LQL.

    If there are no errors, then:

    • The Save LQL button is enabled.

      Results Table - LQL validated

    • In the Column Group Configuration section, the list of attribute groups is replaced with the list of metrics and group-by attributes, contained in a single Default Group column set.
  4. To save the LQL query, click Save LQL.
  5. Under Advanced LQL Options:

    Results Table edit view - Advanced LQL Options

    Enable summary To display a summary row at the bottom of the table, check the checkbox.

    For each column, you then configure whether to display a summary value in the row.

    LQL query threshold (records) In the field, type the maximum number of base records to be processed by the LQL query.

    If the number of records processed is greater than this number, then the end user is prompted to refine the data.

    LQL query threshold message In the field, type the message to display to end users when the number of records processed is greater than the maximum.
  6. To save the configuration changes, click Save Preferences.
  7. To exit the edit view, click Return to Full Page.