Text Filter enables you to filter the items based on value typing in text box. To configure text filter, a minimum requirement of 1 column is needed.
The following procedure explains the data configuration of the Text filter:
Text Filterwidget from the toolbox into the design panel and resize it to your required size. You can find the widget in the toolbox by
Data Sourcebutton in the configuration panel.
CREATE NEWbutton to launch a new connection from the connection type panel.
Microsoft ExcelConnection type is selected for demonstration) of the listed connection type button shown.
NEW DATA SOURCEconfiguration panel, fill the connection type and related details. Click the
Preview & Connectbutton.
Propertiesbutton in the configuration panel, property pane opens.
ASSIGN DATAtab will be opened with the available dimensions from the connected data source.
You can add the
Dimensions to the
Column section by dragging and dropping the required column.
The configured field name can be edited by using the Rename option provided in the settings menu.
The text filter widget allows you to apply filtering for slave widgets by below filtering options.
It perform contains operation. By default, the text filter filtering option will be
It performs starts with operation.
It performs ends with operation.
You can apply filter by initial selection.
You can format the text filter for a better illustration of the view that you require through the settings available in the
Properties tab. This pane can be opened from the design view by clicking the
Settings icon at the top right corner of the widget.
This allows you to set the
title for this text filter widget.
This allows you to set the
subtitle for this text filter widget.
This allows you to set the brief explanation about this text filter widget.
This allows you to define this text filter widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.
This allows you to define this text filter widget to ignore responding to the filter actions applied on other widgets in dashboard.
Using this option, you can enable or disable hierarchical top N filtering. While applying the Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering needs to be done as flat or based on the hierarchy of dimension columns added.
Enable Hierarchical Filtering is enabled, the Top N will be applied for each individual column separately based on the number set for each column.
This allows you to handle the alignment of widget title to either
left, center, or right.
This allows you to apply the text
color to the widget title.
On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.
This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.
On enabling Auto Font Size, the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.
This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.
This allows you to toggle the visibility of
border surrounding the widget.
This allows you to apply the specified
radius to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
This allows you to set the background color to the text filter widget.
This property allows you to specifies the transparency for the
This property allows you to toggle the visibility of
shadow for text filter widget.
This allows you to enable or disable the
widget title of the text filter widget.
This allows you to enable or disable
comment for the dashboard widget. For more details, refer to this link.