Column and Row Selection Tab

This section describes the fields and actions on the Column and Row Selection tab of a web Analyzer workspace.

Column Selection Pane

Use this pane to begin building your report or query. Select the columns you want to include in your customized report.

Pane Actions

Button Description
+ Add column Click this action to open the Select Columns dialog, where you can start adding columns to your customized report.

Pane Fields

Once you add columns to your report, the following fields and icons display on the pane.

Field Description
If you want to move the current column to a different location in the report, click this icon then drag and drop the column line to its new location.
Column Name This field displays the name of the current column.
Subtotal Select this check box if you want your customized report to include subtotals for the current column.
Note: After you add a value column to the report, this check box is grayed out for all non-value columns that come after the value column.
Column Title If you want to rename the current column, enter your preferred name in this field.

Maconomy automatically updates the column name in the Preview pane.

Click this icon to delete the current column from your customized report.
Click this icon to add a new column after the current column line.

Row Selection Pane

Use this pane to specify criteria for selecting the records to display in your report output.

Pane Actions

Button Description
+ Add row selection Click this action to open the Select Columns dialog, where you can start adding the columns to which you want to apply selection criteria or filters.

Pane Fields

Once you select columns to filter for your report, the following fields display on the pane.

Field Description
If you want to move the current column and its restrictions to a different location in the pane, click this icon and drag and drop the column line to its new location.
Click this icon to delete the current column and its restrictions.
Click this icon to add a new column after the current column line.
Column Name This field displays the name of the current column.
If you want to move the current restriction to a different location under the relevant column, click this icon and drag and drop the restriction line to its new location.
Restrictions In the first field, select an operator from the dropdown list. The dropdown includes some or all of the following options:
  • = Equal to
  • x…y Between
  • < Less than
  • > Greater than
  • < Less than or equal to
  • > Greater than or equal to
  • Not equal to
  • Ø Is empty
  • ¬Ø Is not empty

In the second field, type or select the value you want to use to filter values for the current column.

Click this icon to delete the current restriction line.
If you want to specify more than one restriction for the current column, click this icon to add a new restriction after the current restriction line.

Preview Pane

Use this pane to preview the report you are customizing. If you are viewing a saved report or a finished report output, this pane also displays a preview for that. Switch to the full screen view using the Full screen preview icon on the top right corner of the pane.