Datamining Tools - Column Layout, Filter and Sort

Modified on Thu, 22 Jan at 2:11 PM

TABLE OF CONTENTS

Datamining Tools – Column Layout, Filter and Sort
Datamining Report Column Layout Window
Column Layout, Filter and Sort – Canonical Rules
Column Layout, Filter and Sort – Frequently Asked Questions
Column Layout, Filter and Sort – Canonical Rules
Column Layout, Filter and Sort – Frequently Asked Questions

Datamining Tools – Column Layout, Filter and Sort

The Column Layout, Filter and Sort tool is available from the Tools area in the Datamining Report Ribbon.

This tool opens a dedicated window that allows fine-grained control over how report columns are displayed, grouped, filtered, sorted, formatted, and hidden.

These settings affect presentation only and do not modify underlying data.

Datamining Report Column Layout Window

The Column Layout window displays a grid containing one row per report column.

Each row represents a column in the report, and each cell provides editable options that control how that column behaves in the final report output.

Display Name

The display name shown in the report grid.

This value is initially populated from the Admin configuration but can be edited locally for the report.

Changing the Display Name:

Affects only the current report
Does not modify the internal column name
Does not affect Admin configuration

Group Name

Allows related columns to be visually grouped under a shared group header.

Columns with the same Group Name value are rendered together in the report, improving readability for wide or complex reports.

Display Format

Controls how numeric and date values are formatted in the report grid.

Examples:

N0 – Number with no decimal places
N1 – Number with one decimal place
yyyy MMM dd – Date formatted as 2026 Feb 03

Hide Column

Hides the column from the final report output.

Hidden columns are removed after the report is built.

This allows hidden columns to:

Be referenced by Dynamic Columns
Be used in Expressions and Colour Rules
Support filtering or calculations without being displayed

Hiding unused construction columns can also reduce bandwidth for large reports.

Sort Order

Defines the order in which the report is sorted by this column.

Multiple columns can be used for sorting by assigning incremental sort orders.

Example:

1 – App Vendor
2 – App Name
3 – App Version

Sort Descending

Controls the sort direction for the column.

By default, sorting is ascending (A → Z or 1 → 9).

When enabled, sorting is descending (Z → A or 9 → 1).

Filter And / Or

Controls how multiple column filters are combined.

When two or more filters are defined, they can be combined using:

AND – all filter conditions must be met
OR – any filter condition may be met

Filter Expression

Applies a filter condition to the specific column.

The column name is implied, so only the comparison expression is required.

Example:

If filtering the TimeInProcess_Total column, enter: > 30

This filters the report to rows where the total time in process is greater than 30.

Internal Name

The fixed internal name of the column.

Internal names are required when working with:

Expression Columns
Colour Rule Columns
API integrations

Column Order

Column order is controlled by dragging rows up or down in the Column Layout grid.

The vertical order of rows in the window determines the left-to-right order of columns in the report.

Column Layout, Filter and Sort – Canonical Rules

Column Layout settings affect presentation only.
Hidden columns are removed after report execution.
Hidden columns remain available for Expressions and Colour Rules.
Filter expressions apply only to the column they are defined on.
Multiple filters can be combined using AND or OR logic.
Sorting supports multiple columns with explicit precedence.
Column order is determined by row order in the layout grid.

Column Layout, Filter and Sort – Frequently Asked Questions

Why can’t I see a column that I need for my expression?

The column may be hidden. Hidden columns are removed from the grid output but remain available for Expressions and Colour Rules.

Why did my filter not work as expected?

Filter expressions apply only to the column they are defined on, and the column name is implied. Ensure the comparison operator and value are correct.

Why are my filters behaving like OR instead of AND?

When multiple filters are defined, the Filter And / Or option controls how they are combined. Verify the selected join type.

Why did my column order change?

Column order is controlled by dragging rows in the Column Layout window. The vertical order of rows determines the report layout.

Does hiding a column improve performance?

Hiding columns can reduce bandwidth and grid rendering overhead for large reports, but it does not change the underlying data retrieval.