Freeform Dashbording : Configure dashboard components in Presto Freeform : Define filters for dashboard components
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
1. Create or open a dashboard in Presto Freeform.
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.
Now you can Use interactive filter in Freeform dashboard.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback