Goldfinch Analytics Visualization allows you to filter data across reports and dashboards effectively. This document outlines possible search filters available for different data types, enabling you to filter based on conditions like “is null,” “is not null,” “equals,” “not equals,” and ranges. These examples demonstrate query syntax for filtering string, date, number, and float fields.
Note: You can apply filters in the Global Search Engine, at the widget level, and within discovery reports.
Supported Filter Conditions and Syntax
| Field Type | Condition | Query Syntax Example |
| String | Is Not Null | Field:[* TO *] |
| Is Null | NOT Field:[* TO *] | |
| Equals | Field:”Value” | |
| Not Equals | NOT Field:”Value” | |
| Contains | Field:*substring* | |
| Does Not Contain | NOT Field:*substring* | |
| One Of | (Field:”Value1″ OR Field:”Value2″) | |
| Date | Is Not Null | DateField:[* TO *] |
| Is Null | NOT DateField:[* TO *] | |
| Equals | DateField:”yyyy-MM-dd” | |
| Not Equals | NOT DateField:”yyyy-MM-dd” | |
| Before | DateField:{* TO yyyy-MM-dd} | |
| After | DateField:{yyyy-MM-dd TO *} | |
| Between | DateField:[yyyy-MM-dd TO yyyy-MM-dd] | |
| Number | Is Not Null | NumberField:[* TO *] |
| Is Null | NOT NumberField:[* TO *] | |
| Equals | NumberField:Value | |
| Not Equals | NOT NumberField:Value | |
| Greater Than | NumberField:{Value TO *} | |
| Less Than | NumberField:{* TO Value} | |
| Between | NumberField:[MinValue TO MaxValue] | |
| Float | Is Not Null | FloatField:[* TO *] |
| Is Null | NOT FloatField:[* TO *] | |
| Equals | FloatField:Value | |
| Not Equals | NOT FloatField:Value | |
| Greater Than | FloatField:{Value TO *} | |
| Less Than | FloatField:{* TO Value} | |
| Between | FloatField:[MinValue TO MaxValue] |
Example Queries in Goldfinch Visualization
Here are sample queries that demonstrate the filter syntax in various scenarios. Note that if there is a space within a column name, add a backslash \ between the words. If there is no space, a backslash is unnecessary.
- Customer Code Is Not Null
(Customer\ Code:[* TO *]) - Order Status Not Equal to “Order Complete”
(NOT Order\ Status:”Order complete”) - Purchasing Amount Not Equal to 0
(NOT Purchasing\ Amount:0) - Combining Conditions Using Brackets
(Customer\ Code:[* TO *]) AND (NOT Order\ Status:”Order complete”) AND (NOT Purchasing\ Amount:0) - Example with Logical Operators
(NOT Current\ Employee:[* TO *]) OR (NOT Employee\ Type:[* TO *]) OR (NOT Function:[* TO *]) OR (NOT Reporting\ Manager:[* TO *]) - Multiple Filters on the Same Field
(Project:”Guided Navigation”) AND (NOT percentComplete:”100″) AND (Priority:”P0″ OR Priority:”P1″)
Best Practices for Filtering
- Use Parentheses ( … ): Group different conditions to enhance readability and ensure the proper application of logical operators (AND, OR, NOT).
- Logical Operators: Apply these operators carefully to maintain the correctness of your queries.
This guide should serve as a reference for using filters across Goldfinch Visualization. Use these examples to build queries tailored to your specific reporting needs.
