Advanced Analytics

The Advanced Analytics module provides users with the ability to create graphs and generate reports based on their Analytics queries. The query results and their accompanying graphs can be shared as links sent via email or as tabs in Smart Workspace.

Creating Graphs

Graphs for Analytics queries are configured through the SQL Query dialog, which displays a Graph Options button when a user has the Analytics: Advanced Analytics task permission.

Query Requirements

• The result set must include at least two columns.
• Any column that will be used as a data source for the Y axis cannot contain non-numeric data.
• X values are always graphed in ascending order.

Simple Graphs

• The first column is automatically mapped to the X axis, while all other columns are mapped to the Y axis.
• Data is automatically grouped by the first column.
• If a graph type does not support multiple Y values, only values from the second column will be displayed.