You may also apply conditions to your charts by adding related fields to Filter by. This allows you to extract only the values that fulfill a specified condition in your parameters just as you would define it in the WHERE clause of your SQL query. In the following steps we will demonstrate how to implement the WHERE condition in your drag and drop charts and how to define parameters for your charts.


Note: In order to add fields from other tables or data sources to Filter by,make sure these tables are joined using foreign keys in the settings section.


Setup a WHERE condition


  1. In the Chart Creator, add your metrics and variables to Measures & Dimensions.
  2. Then add the column you would like to use to define your parameters to Filter by. In the field editor on the right side of the screen you will now have the option to create formulas and conditions. Depending on the data format of the field in Filter By you will have the following options:

Text Fields


how to filter by text fields


The values of a text field may be included or excluded. Select or deselect the values by which your chart should be filtered. Only the values selected will be included or excluded from the calculation and affect the measured value in the Y-axis of your chart.


 Number Fields/ Boolean Values


how to filter by number fields


Number fields and Boolean Values can be filtered by adding a defined criteria to the field. Please click here to see how to define custom criteria for number and Boolean values in Filter by.


Date Fields


how to filter by date fields


The observation period for date fields in filter by can be either static or dynamic including             different time periods, such as today, last month or this year.