WHERE <Aggregation_Function>(<table>.<column_name>, <start>, <end>) <comparison_operator> <constant>
(Optional)WHERE
clause filters data before running predictions, allowing you to exclude irrelevant entities or targets from aggregation. Filters can be static (based on direct column values) or temporal (using aggregations over time).
user
to region
to ensure each user belongs to a single region.
WHERE
Within an AggregationWHERE
filters exclude irrelevant entities or targets before aggregation.
AND/OR/NOT
.