FIRST(<table>.<column>, <start>, <end>, <unit>)
<table>.<column>
column starting from <start>
days to <end>
days. When used in the target field, the time period should be positive (in the future). When used in a temporal filter field, the time period should be negative (in the past).
This operator can be applied to any columns except the ones which are foreign keys.
days
by default but can be specified as months
or hours
. If you would like to predict periods with no interactions, you may use the IS NULL
or IS NOT NULL
operators.