To access the stats package click on the Stats icon on the left.

At the top of the page you can choose your Source. You can only work with one dataset at a time. You can save as a Report, Print, and Export as HTML, CSV, EXCEL, IMAGE, or PDF.

You can view your data as a Grid or as a Chart of your choosing.

Options

Options allows you to configure your layout options such as grand totals and subtotals. Use the Layout section to switch between Compact, Classic, and Flat views.

  • Compact form displays the data as a compressed pivot view, with the selected fields as rows in a single hierarchical column.
  • Classic form displays the results as a pivot view, with the selected fields as separate rows and columns, with totals at the end of each row.
  • Flat form displays the results as a flat table with all of the query's fields as separate columns.

Fields

Both the Fields tab and the downward diagonal arrow at the top left of the page open the Field popup.

The Fields popup allows you to define which data is shown on the grid or charts.

At the left you have all the hierarchies from the original data source. A hierarchy is a list of nested columns in a data table that are considered as a single item.

Drag & drop hierarchies from the left part of the Fields list to the Rows, Columns, Values, or Report Filters boxes. Each box can have as many hierarchies as you wish. The order of the hierarchies inside the box can also be changed by dragging and dropping.

Each value requires an aggregation function applied to it. Depending on the data source type, numeric hierarchies support between 7 and 13 different aggregation functions. String hierarchies can also be selected for values, but the only available aggregation functions are count and distinct. By default, numeric hierarchies are aggregated using sum, and string hierarchies using count.

You can change the aggregation function by pressing the sigma icon and choosing a new one. Choose ‘Add calculated value’ at the top of the Field List to add a calculated value.

Format

The Format tab provides two options: Format cells for number formatting and Conditional formatting.

Number formatting can be applied through the Format cells pop-up.

Select the value to which the format should be applied from the drop-down list. You can modify any of the following properties: text align, thousand separator, decimal separator, decimal places, currency symbol, currency align, null value, and format as percent.

The Conditional formatting pop-up can be opened by clicking Format in the Toolbar and choosing Conditional formatting.

You can apply the condition either to ‘All values’ or to the specific measure from the drop-down list.

Select condition type and value, font family and size. Click the A-letter icon to replace the default font and background colours. Choose the new colours from the colour picker or enter the hex codes.

Pivot Charts

Use pivot charts to visualize your data in a new way.

Choose the chart type from the drop down.

To Filter values select the filter located at the top right and choose the parameters you would like to view.

Click twice on the graphic elements to drill through and see the raw data.

If there are multiple hierarchies in the rows or columns, expand or collapse the inner values by clicking the plus sign to the left of the hierarchy name.

Did this answer your question?