Define filters for dashboard components
In the
Freeform Dashboard editor you can define relations between components by specifying filter conditions for selected component. The defined filters can be used in the
Freeform Dashboard viewer (See
Use interactive filter in
Freeform
dashboard).
Most components of the Dashboard support data filters. Particularly the
Drop-down box and
Input field provide you with a selection of values in a drop-down menu or a manual data input for filtering other dashboard components. (See
Insert Drop-down box in a dashboard and
Insert Input field in a dashboard).
Procedure
2. Click on an inserted component, e. g. Line chart, Drop-down box or Grid. The relevant properties dialog is displayed.
3. Click the Filter icon to edit the filter configuration. The selected component, the data source columns and the Select filter component dialog will be displayed. If applicable defined Input fields will be displayed as filter components. 4. Drag a column that you want to be filter in the Source Columns box and drop the selected column in the Drop her to define a new filter field. The Define filter condition dialog will be displayed. All components that can be used as filter will be highlighted. The columns in the Available Coordinates box of each component can be used as filter condition values.
5. Define the filter condition.
You can use a column or a constant value as filter condition.
a. Select a condition in the drop-down menu, e.g. starts with.
b. Drag a coordinate in the Available Coordinates box of a the component that you want to use as filer component. And drop the selected coordinate in the empty filter condition field.
c. Alternatively, you can enter a constant value as filter condition.
d. To consider the case sensitivity click the Match case / Ignore case icon. It's only available for coordinates or values of type text. e. If you want the filter conditions to be considered as fulfilled even if the selected values are empty click the Empty comparevalues are accepted icon. f. Click the Add icon to add a filter condition. g. Activate the block values option to block the rows which meets the condition.
6. Click Define new filter to add filters on other source columns.
7. Click Save filter.
Your filter conditions are saved.