Holistics Docs - End-to-End Business Intelligence Platform

Holistics Documentation

Welcome to the Holistics Documentation page. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started

Date Filters

What is Date Filter?

Date Filter is one of the manual-input filter types that can create filtering conditions on time-base fields.
For example:

  • To see revenue on a specific date
  • To see user growth in the last 3 weeks

Date Filter can be applied to fields of Date and Datetime data type.

Date Operators

  • last, next: when selecting these operators, you can also choose a modifier to specify the time unit (day, week, month, year)
  • between
  • before
  • after
  • is on
  • is null
  • is not null

Matches

Using NLP, matches operator can smartly translate the text you input to a time range.

Examples of valid syntax:

  • yesterday
  • monday last week
  • last 2 months
  • 3 weeks ago till today
  • next 3 years in the future
  • 19:00 yesterday to now
  • Dec 2018 - 1/1/2020
  • 1998 - 2018

Exact date

Both absolute and relative date values are acceptable.

Format

Description

Example

DD MMM YYYY, MMM DD YYYY

01 April 2020, April 01 2020

DD-MM-YYYY, YYYY-MM-DD

01-04-2020, 2020-04-01

DD/MM/YYYY, YYYY/MM/DD

01/04/2020, 2020/04/01

today, yesterday, tomorrow

[weekday] this week

monday this week, wed this week

[weekday] next/last x week(s)

tuesday last 2 weeks, fri last 3 weeks

[time period] begin/end

The first/last day of the time period. Time period can include:

  • this year/ month/ week
  • last x year(s)/ month(s)/ week(s)
  • next x year(s)/ month(s)/ week(s)

Today is Mar 15, 2020.
last month begin will translate to Feb 01, 2020.

x day(s) ago

1 day ago, 2 days ago

Date / Time range

Note: We only support Date Range at the moment, please leave us a note if Time range is critical to you.

Format

Description

Example

MMM YYYY

Cover all dates in a month.

April 2020, Mar 2020

YYYY

Cover all dates in a year.

2019, 2020

[start date] -/to [end date]

Cover all dates in range, including end date. [date] accepts both absolute and relative values.
Note: there must be spaces around the hyphen

2020-03-01 to 2020-04-01, last month end - today

[start date] till/until [end date]

Cover all dates in range, excluding end date.

2020-03-01 till 2020-04-01, last month end until today

last x year(s)/ month(s)/ week(s)/ day(s)

Cover all dates in the previous x units, except the current year/ month/ week/ date.

Today is Mar 15 2020. last 2 years covers 2018 and 2019, last 2 months covers Jan and Feb 2020

x year(s)/ month(s) /week(s) ago

Cover all dates in a single month/year/week at x units before the current time.

Today is Mar 15 2020. 2 months ago covers the whole January, 2 years ago covers 2018.

next x year(s)/ month(s)/ week(s)/ day(s)

Cover all dates in the next x units, except the current year/month/week/date

Today is Mar 15 2020. next 2 years cover 2021 and 2022, next 2 days cover Mar 16 and 17.

Updated about a month ago

Date Filters


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.