Filter Settings
The filter settings will depend on the column’s type and filter mode
Steps:
1. Click on a filter column name under the Filter Box columns list.
The filter properties are displayed that you can adjust.
2. By default, the Title is the column name added to the filter box. You can opt to modify this value.
3. You can opt to select another Data Table from the drop-down list and then select the filter Column.
4. The filter properties depend on the column type.
· For text columns:
The default Mode type depends on the column type and the number of values. Refer to Filter Mode Types for more information.
For text columns with Free text filter mode type, select the Default Wildcard:
¨ Substring
The wildcard character is a substring to search for certain values in the Free Text filter box.
For example, entering Bank displays values (maximum of 10) that contain Bank.
¨ Prefix
The wildcard character is a substring to search for certain values in the Free Text filter box.
For example, entering Bank displays values (maximum of 10) that begin with Bank.
Set the Suggestion List Max Size with the custom limit on how many options/suggestions should be, at the most, loaded and presented on the drop-down. Default is 10.
Enter a description or useful information about the filter into the Tooltip box.
· For numeric and timeseries columns:
¨ Select the Divide By value to divide a number:
o 1
o 1000 (by a thousand)
o 10000
o 1000000 (by a million)
o 1000000000 (by a billion)
¨ Specify the Format that numbers will be displayed in. Panopticon uses the same formatting rules as Excel.
· For Date/Time columns:
Specify the Date/Time Format.
4. Tap the Append Separator slider to add a separator after a column filter.
5. Click the Save icon on the toolbar to save the changes.
When saved, the notification is displayed.