Filter Expressions - Yesno

Example

b.is_paid:  ### SQL interpretation ###
- 'any' #'any' = 'any'
- 'yes' #VALUE = 'Yes'
- 'no'  #VALUE = 'No'

# VALUE for dimension of type 'yesno_is_true' evaluates as:
# CASE WHEN (sql) IS TRUE THEN 'Yes' ELSE 'No'

# VALUE for time of timeframe 'yesno_has_value' evaluates as:
# CASE WHEN (sql) IS NOT NULL THEN 'Yes' ELSE 'No'

Description

Expression	Description
any	is any value (same as no filter)
yes	matches if field (after evaluation) is equal to "Yes"
no	matches if field (after evaluation) is equal to "No"