Page 21 - Unanet AE: Creating Analytic Models Using Query Builder

The following settings are available for each column.

Use Column to select the required column from the combo box or add a new column. If

Use Column to select the required column from the combo box or add a new column. If
necessary, you can customize a column expression. To do this, click the ellipsis button
for the required column and specify the expression in the open dialog.
• The Table column displays corresponding table names.
• The Alias column allows you to specify the column alias, or display name.
Note: Aggregated columns should always have an alias.
• The Output column allows you to choose whether to include specific columns to
the query.
• Use the Sorting type combo box to specify the sort order of column values. The
Sort order column allows you to specify the order in which several columns are
sorted.
• The Group By statement is used in conjunction with the aggregate functions to
group the result-set by one or more columns.
• The Aggregate option allows you to specify the aggregate function used to
aggregate column values.
Note: You should apply aggregation/grouping either to all columns or to none of
them.

LESSON 3: Building Queries In the Analytic Dashboard ©2024 Unanet. All rights reserved. 21
Designer