Filter Filters allow you to filter data in a chart.Filters Filters are made up of a set of clauses; each clause in turn contains a number of conditions.
You can name a and save filters for future use, or use them temporarily.
Buttons:
| Apply the filter without saving it. |
| Save without closing. | |
| Save and close. |
Filter tab
If you want to save this filter for future use, enter details and save.
| Field | Description |
|---|---|
| Name | The name of the Filter. |
| Private | This field will only be visible to users with the 'Create Public Filters' privilege. Tick this field if this Filter should only be available to the user who created it. If this field is not visible then the filter will be private. |
| Protect during import | Tick this field to prevent this Filter being updated or deleted during import. |
| Access Permissions | |
| This section will only be visible to users with the 'Create Public Filters' privilege. | |
| All Users Can View Filter | This field is only visible if Private is not ticked. Tick this field if all users with permission to view filters should be able to view this filter. |
| User Groups | If 'All Users Can View Filter' is not ticked, select the user groups who will be able to view this filter. |
Build a filter by adding conditions and clauses in this tab.
| Add a clause to the filter. Hover over the editor to the right of a condition to see this button. |
 | Delete the selected clause or condition from the filter. Hover over the editor to the right of a condition or clause to see this button. |
 | The value entered is a literal value. Click this icon to change this, if you want to use an expression. |
 | The value entered is an expression. Click this icon to change this, if you want to enter a literal value. |
Create prompt filter
You can create a filter that will prompt users to enter a value, and filter based on that. For example, if you have data which contains people's names, you could create a filter like:
Name contains _prompt.EnterName fx
Filter on Current User
If you your data contains details of the user, you may be able to filter based on the currently logged in user. For example, to set a filter where the owner equals the current logged in user, add a condition to the filter:
...
Country Is in ["England","France","Germany"] fx
Details tab
...
Description tab
| Field | Description |
|---|---|
| Name | The Name of the Filter. |
| Private | Tick this field if this Filter should only be available to the user who created it.|
| Description | Description of the Filter. |
...