LIST_DISTINCT(<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 columns of any type.
For an optimal user experience, Kumo recommends limiting the use of LIST_DISTINCT
to cases where the number of possible return values is less than 1000.
IS NULL
or IS NOT NULL
operators.days
by default but can be specified as months
or hours
.