NOTE: All the example Questions in this page use this Example Dataset.

Using Filters

Filters are used to target a specific group of Data-points when computing Measures. Filters can be used in three different ways:

  1. Using a Filter at the end of a Question will filter the Data-points for the entire Question.
    Example: SALES, PROFIT ACROSS CITIES IN 2018
  2. Using a Filter at the end of a Measure will filter the Data-points for just that Measure.
    Example: SALES IN 2018, PROFIT ACROSS CITIES
  3. You can also use Filters inside Functions. Please see Function Components for more details.
    Example: SUM(PROFIT WHERE PROFIT > 0) ACROSS CITIES

Types of Filters

Vizard supports three types of Filters: 1) Value Filters, 2) Special Time Filters and 3) Logical Filters

Value Filters

Value filters can be constructed using an IN/FOR/OF Keyword followed by the value of a Dimension.

Examples:

Special Time Filters

You can use the following special Time Filters with/without an IN/FOR/OF Keyword:

Examples:

Logical Filters

Logical filters can be constructed using a WHERE/WHEN Keyword followed by a Comparison. e.g. WHERE PROFIT > 0

In a Comparison, we compare a Measure against a value using Comparators. The supported Comparators are:

Examples:

You can combine multiple Comparisons using the Logical Operators AND/OR and parentheses (as needed).

Examples: