SELECT Query Fields

Click Add SELECT columns to select the data for the query. Data selected enters one big bucket, and any functions set for any of the data fields is performed on the entire bucket of data.

Tip: Fields in shown in italics on the Data Options panel are derived, referenced, or side table fields (rather than “hard event data” in the main database tables). See also, Data Fields and Variables.

Query Structure (SELECT)

The Query Structure section at the top provides a summary of the fields selected in the SELECT section at the bottom. If you add GROUP BY or ORDER BY settings, these show up here also.

You can select from Fields and Global Variables, Field Sets, or Local Variables as data to build the query. Choosing a field set limits the fields shown to the selected field set.

You can also select a condition item and right-click to get the various Edit options (Edit, Copy, Delete, Duplicate, and so forth).

Applying Functions to SELECT Columns

Optionally, you can specify an aggregate function on a particular column of data, such as a line item count, or in the case of numeric data, a sum or average

If the query is not grouped by one or more columns, then aggregate functions added here are applied to the whole result set.

If the query is grouped by one or more columns, then the aggregate function is performed on each group individually.

Adding a function adds a data field to the query schema that provides the results of the function, which can later be displayed in a report.

To specify a function for column data, double-click a field or variable in the top pane under SELECT and select a Function from the drop-down menu to apply to the column data.

The available functions are:

Select Unique to apply the function only to unique values in the column. For example, the target address column may have 50 items in it, but only three are unique. To get a count of unique target addresses, check the Unique box.

Click the green checkmark button () to add the function.

To remove a function from a field, select the field, change the function selection to None, and click the green checkmark button again.

To cancel a modification to a function, click the () button or simply click elsewhere on the UI (off of the Function menu.)