SUM - AVG - Count

Sum

Equals

• Definition: Checks if the sum is exactly equal to a specific value.

• Use Case: Useful for exact matches.

  • Example: Filter customers who have spent exactly $500.

    • total_spend Equals 500

NotEquals

• Definition: Checks if the sum is not equal to a specific value.

• Use Case: Excludes specific totals.

  • Example: Exclude customers who have spent exactly $0.

    • total_spend NotEquals 0

EqualsOneOf (Old "In" Filter)

• Definition: Checks if the sum matches one of the values in a predefined list.

• Use Case: Useful for matching multiple specific totals.

  • Example: Filter customers who have spent $100, $200, or $300.

    • total_spend EqualsOneOf [100, 200, 300]

EqualsNoneOf (Old "NotIn" Filter)

• Definition: Checks if the sum matches none of the values in a predefined list.

• Use Case: Excludes multiple specific totals.

  • Example: Exclude customers who have spent $0, $50, or $100.

    • total_spend EqualsNoneOf [0, 50, 100]

GreaterThan

• Definition: Checks if the sum is greater than a specific value.

• Use Case: Useful for filtering totals above a certain threshold.

  • Example: Filter customers who have spent more than $500.

    • total_spend GreaterThan 500

GreaterThanOrEquals

• Definition: Checks if the sum is greater than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers who have spent at least $500.

    • total_spend GreaterThanOrEquals 500

LessThan

• Definition: Checks if the sum is less than a specific value.

• Use Case: Useful for filtering totals below a certain threshold.

  • Example: Filter customers who have spent less than $100.

    • total_spend LessThan 100

LessThanOrEquals

• Definition: Checks if the sum is less than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers who have spent $100 or less.

    • total_spend LessThanOrEquals 100

IsEmpty

• Definition: Checks if the sum field is empty (i.e., no value is present).

• Use Case: Useful for identifying customers with no recorded totals.

  • Example: Filter customers who have no recorded total spend.

    • total_spend IsEmpty

IsNotEmpty

• Definition: Checks if the sum field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring that all customers have a recorded total.

  • Example: Filter customers who have a recorded total spend.

    • total_spend IsNotEmpty

Avg (Average)

Equals

• Definition: Checks if the average value is exactly equal to a specific value.

• Use Case: Useful for exact matches.

  • Example: Filter customers whose average spend per purchase is exactly $50.

    • average_spend Equals 50

NotEquals

• Definition: Checks if the average value is not equal to a specific value.

• Use Case: Excludes specific averages.

  • Example: Exclude customers whose average spend per purchase is $0.

    • average_spend NotEquals 0

EqualsOneOf (Old "In" Filter)

• Definition: Checks if the average value matches one of the values in a predefined list.

• Use Case: Useful for matching multiple specific averages.

  • Example: Filter customers whose average spend per purchase is $50, $75, or $100.

    • average_spend EqualsOneOf [50, 75, 100]

EqualsNoneOf (Old "NotIn" Filter)

• Definition: Checks if the average value matches none of the values in a predefined list.

• Use Case: Excludes multiple specific averages.

  • Example: Exclude customers whose average spend per purchase is $0, $10, or $20.

    • average_spend EqualsNoneOf [0, 10, 20]

GreaterThan

• Definition: Checks if the average value is greater than a specific value.

• Use Case: Useful for filtering averages above a certain threshold.

  • Example: Filter customers whose average spend per purchase is greater than $100.

    • average_spend GreaterThan 100

GreaterThanOrEquals

• Definition: Checks if the average value is greater than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers whose average spend per purchase is at least $100.

    • average_spend GreaterThanOrEquals 100

LessThan

• Definition: Checks if the average value is less than a specific value.

• Use Case: Useful for filtering averages below a certain threshold.

  • Example: Filter customers whose average spend per purchase is less than $50.

    • average_spend LessThan 50

LessThanOrEquals

• Definition: Checks if the average value is less than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers whose average spend per purchase is $50 or less.

    • average_spend LessThanOrEquals 50

IsEmpty

• Definition: Checks if the average field is empty (i.e., no value is present).

• Use Case: Useful for identifying customers with no recorded averages.

  • Example: Filter customers who have no recorded average spend.

    • average_spend IsEmpty

IsNotEmpty

• Definition: Checks if the average field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring that all customers have a recorded average value.

  • Example: Filter customers who have a recorded average spend.

    • average_spend IsNotEmpty

Count

Equals

• Definition: Checks if the count is exactly equal to a specific value.

• Use Case: Useful for exact matches.

  • Example: Filter customers who have made exactly 5 purchases.

    • purchase_count Equals 5

NotEquals

• Definition: Checks if the count is not equal to a specific value.

• Use Case: Excludes specific counts.

  • Example: Exclude customers who have made exactly 0 purchases.

    • purchase_count NotEquals 0

EqualsOneOf (Old "In" Filter)

• Definition: Checks if the count matches one of the values in a predefined list.

• Use Case: Useful for matching multiple specific counts.

  • Example: Filter customers who have made 1, 3, or 5 purchases.

    • purchase_count EqualsOneOf [1, 3, 5]

EqualsNoneOf (Old "NotIn" Filter)

• Definition: Checks if the count matches none of the values in a predefined list.

• Use Case: Excludes multiple specific counts.

  • Example: Exclude customers who have made 0, 2, or 4 purchases.

    • purchase_count EqualsNoneOf [0, 2, 4]

GreaterThan

• Definition: Checks if the count is greater than a specific value.

• Use Case: Useful for filtering counts above a certain threshold.

  • Example: Filter customers who have made more than 10 purchases.

    • purchase_count GreaterThan 10

GreaterThanOrEquals

• Definition: Checks if the count is greater than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers who have made at least 10 purchases.

    • purchase_count GreaterThanOrEquals 10

LessThan

• Definition: Checks if the count is less than a specific value.

• Use Case: Useful for filtering counts below a certain threshold.

  • Example: Filter customers who have made fewer than 5 purchases.

    • purchase_count LessThan 5

LessThanOrEquals

• Definition: Checks if the count is less than or equal to a specific value.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter customers who have made 5 or fewer purchases.

    • purchase_count LessThanOrEquals 5

IsEmpty

• Definition: Checks if the count field is empty (i.e., no value is present).

• Use Case: Useful for identifying customers with no recorded counts.

  • Example: Filter customers who have no recorded purchase count.

    • purchase_count IsEmpty

IsNotEmpty

• Definition: Checks if the count field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring that all customers have a recorded count value.

  • Example: Filter customers who have a recorded purchase count.

    • purchase_count IsNotEmpty