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
- Select the chart, and click
- On the Representation tab, click the cross
- Close the Settings window.
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.
To filter data in the remaining columns of a table chart often requires using an operator. Following operators can be used:
|==||value is |
|<||values smaller than ||<50|
|>||values larger than ||>medium (list value)|
|<=||values equal to or smaller than ||<=8|
|>=||values equal to or larger than ||>=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)