Knowi widget filters have the same functionality as their dashboard counterparts with the added benefit of also being able to incorporate Knowi's highly flexible cloud9QL function to further manipulate the data contained in a particular widget.
Filtering a Widget using Cloud9QL Transformations
One way to filter a widget is to apply cloud9ql transformation directly to the widget.
1. Click the Filters button on the widget you want to modify.
2. At the bottom of the filters panel, find and click the Cloud9QL Transformations button.
3. In the text box that appears, type in Cloud9QL code to transform the data in the widget as needed.
4. Click Save to apply the transformation.
5. Return to the dashboard to view the updated, filtered widget.
Filtering a Widget using Widget-level Filters
Another option is to set widget level filters in a similar manner to setting dashboard level filters. See the dashboard filter documentation for more details.
1. Click the Filters button on the widget you want to modify.
2. In the filters panel, click the orange Add button.
3. Enter the field name you want to filter, select the condition type, and provide the value for the filter.
4. Click Save to apply the filter.
The filter will function like dashboard-level filters but will only affect the selected widget.
Widget Filter Settings
Widget Filter settings allow users to configure the widget filters. Navigate to the gear icon in the widget filters to access the widget filter settings.
Click the settings icon.
| Filter | Interpretation |
| Cascading Suggestions | Suggestions for filters will be in the order of filters enabled. For example, if there are three filters for Country, State and County, enabling this will display states for the country selected, and counties will be based on the Country and State selected. |
| Widget Field Filters | Filters on the widget fields, after any widget-level data processing. |
| What fields should a user be able to filter on? |
Allows users to control the fields on which the filters are allowed |