FILTER=FIELD|OPERATOR|VALUE

FILTERSET=FIELD_1|OPERATOR|VALUE;FIELD_2|OPERATOR|VALUE[|LOGICAL_OPERATOR]


A field can be:

  • A datapoint property
  • An attribute of a group member
  • An aggregate field



An operator can be:

  • eq - Equal (=) to VALUE
  • ne - Not equal (!=) to VALUE
  • gt - Greater than (>) VALUE
  • lt - Less than (<) VALUE
  • gte - Greater than or equal (>=) to VALUE
  • lte - Less than or equal (<=) to VALUE
  • like - For strings: string is like VALUE
  • likewild - For strings: string begins with VALUE



A value can be:

  • A static value
  • The result of EVALCONST
  • The result of EVALTAG


A logical operator can be:

  • AND - Requires first AND second condition to both be true (default)
  • OR - Requires either first condition OR second condition (or both) to be true



Examples:

#only include datapoints with a score higher than 90

{|RESULT|FILTER=SCORE|gt|90}


#only show locations with an average score higher than 90

{|LOOP|RESULT.LOCATION(FILTER=AVG(SCORE)|gt|90)}


#only include datapoints done on a saturday or sunday

{|RESULT|FILTERSET=DAY_OF_WEEK_ID|eq|6;DAY_OF_WEEK_ID|eq|7|OR}


#only include datapoints with a location name starting with 'New'

{|LOOP|RESULT.DATAPOINTS(FILTER=LOCATION.NAME|likewild|New)}


#only show datapoints with a score that is not NULL

{|LOOP|RESULT.DATAPOINTS(FILTER=SCORE|ne||EVALCONST(NULL)|)}


#only show datapoints with an answer of 1 or 2 to question 51 and an overall score over 90

{|RESULT|FILTERSET=QUESTION_51_ID|eq|1;QUESTION_51_ID|eq|2|OR;PERCENT_SCORE|gt|90}