Filter Matrix

The Filter Matrix allows to filter data on a dashboard based on property values (SKOOR objects) or values from database tables.

The filter matrix can either be configured in accordion (screenshot above) or dropdown mode:

The widgets in the dashboard can be connected to a filter matrix to apply any selections.

Editing filter matrix widget

Setting	Description
Search type	Select one of Deep Search (for SKOOR objects), Data Source or Data Query
Required mandatory fields	Specifies whether all mandatory fields or at least one (any) mandatory field need to be set.
Keep filters	If Keep filters is active, the selection is not cleared on a page change.
Selector type	Accordion or dropdown

Filter definitions

A filter definition applies to one column of a database table or one property of SKOOR objects. Every filter definition is displayed as one section in the filter matrix.

Setting	Description
Property	Property to get distinct filter values for. Only available in Deep Search mode.
Column	Column to get distinct filter values for. Only available in Data Source/Data Query mode.
Label Column	Column of the value to be displayed instead of the Column value. Defaults to the Column value if omitted.
Sort Mode	None: Does not perfom any sorting. Column/Property: Performs an alphanumeric sort on the Column/Property values. Label Column: Performs an alphanumeric sort on the Label Column values. Uses the Column values if no Label Column is set.
Name	Name of the filter. If accordion mode is selected, this name is displayed in the accordion part header.
Selection	Single (only one value selectable at a time) or multi selection.
Default value	Value which is preset if filter matrix gets loaded or reset.