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. Range (only if the values are numerical)
Default value	Value which is preset if filter matrix gets loaded or reset.

Numeric Range Slider

Adding a filter definition to the FilterMatrix with numerical value would enable Range selection mode.

This divides the values into buckets, and allows the user to adjust the filter by sliding a start and end values of the range.

Values could be adjusted also by typing in the values in the entry field.

Unit Conversion

Numerical values' filters are even more customizable with the unit conversion support.

By simply selecting a source/target unit the conversion is done with ease.

Using Best unit as a target unit, would find the best unit of the median of all values.

Without unit conversion	With unit conversion