Filters in the Compare Page

Filters can be written at the top of the compare page, which is accessible from the project detail page. Users write filters to select for only the rows they wish to visualize / inspect.

Below is a list of DBNL defined functions that can be used in filter expressions:

function name	aliases	description
and		Logical AND operation of two or more boolean columns
or		Logical OR operation of two or more boolean columns
not		Logical NOT operation of a boolean column
less_than	['lt']	Computes the element-wise less than comparison of two columns. input1 < input2
less_than_or_equal_to	['lte']	Computes the element-wise less than or equal to comparison of two columns. input1 <= input2
greater_than	['gt']	Computes the element-wise greater than comparison of two columns. input1 > input2
greater_than_or_equal_to	['gte']	Computes the element-wise greater than or equal to comparison of two columns. input1 >= input2
equal_to	['eq']	Computes the element-wise greater than or equal to comparison of two columns

Here is an example of a more complicated filter that selects for rows that have their loc column equal to the string 'NY' and their respective churn_score > 0.9:

and(gt({RUN}.churn_score, 0.9), equal_to({RUN}.loc, 'NY'))

Use single quotes ' for filtering of string variables.