Using EQL 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 values generated from an EQL query.

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

Check the Use EQL query checkbox.
The EQL query text area and Advanced EQL Options fields are displayed.
In the EQL query text area, type the EQL query.
When entering the EQL query:
- Do not alias attributes from the physical data.
  For example, if the data source includes a "Region" attribute, then don't define the attribute under a different name, for example:
```
SELECT Region AS RegionList
```
  End users can only refine data using attributes that are present in the physical data. If you alias an attribute, then end users cannot use it to refine the data.
- Do not use the name of an attribute from the physical data source as the name of a derived attribute.
  For example, if you are creating a derived attribute that averages the values of an existing "Sales" attribute, do not define the new attribute as:
```
SELECT avg(Sales) as Sales
```
  Instead, use a different name, for example:
```
SELECT avg(Sales) as avgSales
```
  This is also to prevent end users from trying to refine by an attribute that is not in the physical data.
After entering the query, to validate it, click .
If there are no errors, then the Test EQL button changes to an Apply EQL button.
To revert to the last saved version of the EQL query, click Cancel.
To save the EQL query, click Apply EQL.
The EQL query is applied to the component, and the buttons are disabled.

In the Column Set 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.

Note that if you save the Results Table configuration and exit the edit view without having applied the new EQL query, then the end user view uses the last saved query. The next time you edit the component, the new query is displayed, ready for you to test and apply.

Under Advanced EQL Options:

Results Table edit view - Advanced EQL Options

Enable EQL 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.
EQL threshold (records)	In the field, type the maximum number of base records to be processed by the EQL query. If the number of records processed is greater than this number, then the end user is prompted to refine the data.
EQL threshold message	In the field, type the message to display to end users when the number of records processed is greater than the maximum.

To save the configuration changes, click Save Preferences.
To exit the edit view, click Return to Full Page.