Conditional filter to apply to the date hierarchies (except "date"
type for CSV/JSON that creates separate hierarchies for years, months and days). Accepts dates in "YYYY-MM-DD"
format. Here is a list of all available conditions:
equal
– String. Equal to some date. Example: { "equal": "2018-12-31" }
.not_equal
– String. Not equal to some date. Example: { "not_equal": "2018-12-31" }
.before
– String. Before some date. Example: { "before": "2018-12-31" }
.before_equal
– String. Before or equal to some date. Example: { "before_equal": "2018-12-31" }
.after
– String. After some date. Example: { "after": "2018-12-31" }
.after_equal
– String. After or equal to some date. Example: { "after_equal": "2018-12-31" }
.between
– Array of strings. Between two dates (including them). Example: { "between": ["2018-12-31", "2018-12-31"] }
.not_between
– Array of strings. Not between two dates (excluding them). Example: { "not_between": ["2018-12-31", "2018-12-31"] }
.last
– String. Filter dates of some previous period. Possible values: "day"
, "week"
, "month"
, "quarter"
, "year"
. Example: { "last": "week" }
.current
– String. Filter dates of some current period. Possible values: "day"
, "week"
, "month"
, "quarter"
, "year"
. Example: { "current": "week" }
.next
– String. Filter dates of some next period. Possible values: "day"
, "week"
, "month"
, "quarter"
, "year"
. Example: { "next": "week" }
.