Skip to end of metadata
Go to start of metadata

If a table chart has many records, it can be useful to add a filter row for filtering the data in the table. 

Table chart with filter row at the top

Adding a filter row to the table chart

  1. Select the chart, and click  to open the chart's Settings window.

  2. On the Representation tab, click the cross  next to Show filter row.

  3. Close the Settings window.

Filtering data

Filtering data in the table chart often requires the use of operators. Enter an operator (if needed) and a value, and press Enter. The results are shown in the table. In case of a filtering error, the entered filter value is shown in red preceded by an asterix.

First colum, the "Object"column

The first column in a table chart is always the "Object" column, showing the names of the objects from the selected population. Filtering data in this column does not require using an operator. 

Other columns

To filter data in the remaining columns of a table chart often requires using an operator. Following operators can be used:

OperatorSearch forExample
==xvalue is x or contains value x


<xvalues smaller than x<50
>xvalues larger than x>medium    (list value)
<=xvalues equal to or smaller than x<=8
>=xvalues equal to or larger than x>=low      (list value)

Column with textual values: Use the operators.

Column with numerical values: Use the operators. Only typing a value and pressing Enter will also work (similar to using ==).

Column with list values (numerical or textual): Use the operators.

Column with a custom profile: Use the operators, independent of the value type in the column.

Filtering on money values and dates is not supported.

Example of an unfiltered chart (top), adding 1 filter (middle), and a second filter (bottom)