Filter rows/cells on date range¶
This processor filters rows or cells based on the type of date filter applied: a date range, a relative range, or a date part.
This processor should only be used on columns with meaning ‘Date’, ie. parsed dates.
You can select the action to perform on matching (in range) rows:
Remove matching rows
Keep matching rows only
Clear the content of the matching cells
Clear the content of the non-matching cells
Filter on Date Range
Filter rows in the dataset if the date values in a column fall within the boundaries specified by a static range; these boundaries are inclusive. If the lower bound (From) is left empty, all dates before the upper bound (To) are filtered, and vice-versa. If the column does not contain a valid date for a given row, that row is considered as being outside the specified range.
The provided timezone will be used to filter dates.
Filter on Relative Range
Filter rows in the dataset if the date values in a column fall within the boundaries specified by a relative range; these boundaries are dynamic and will update relative to the time on the local server. The relative range is defined using different date periods (year, quarter, month, day) and times (for example: this year, last N years, next N years, year to date). Note: each period is a calendar period; the last 1 year will filter data for the last complete calendar year.
The dates in the dataset as interpreted using the UTC timezone when filtering on relative range.
Filter on Date Part
Filter rows in the dataset if the date values in a column have the same date part(s) as the one(s) specified in the processor. Data can be filtered on a variety of date parts like year, month, week, weekday, day, specific date…
The dates in the dataset as interpreted using the UTC timezone when filtering on date part.