Enhanced time entity filtering in the Assistant

The Assistant now understands even more time references and can filter based on date phrases like YTD (year to date), QTD (quarter to date), MTD (month to date), and WTD (week to date). The Assistant now also understands additional U.S. holidays or special days, such as Memorial Day and Mother’s Day.

Additionally, the Assistant recognizes certain typos and abbreviations for days of the week, months, and several holidays and special days. For example, the Assistant recognizes:

  • Jan for January
  • Sep or Sept for September
  • Thu, Thur, or Thurs for Thursday
  • Xmas for Christmas
  • Valentines for Valentine’s Day
References to this, last, and next have also been refined:
  • this returns a value for the month, week, or holiday that is in the current calendar year
  • next returns a value for the next occurrence of day, month, or holiday in the future
  • last returns a value for the occurrence of the day, month, or holiday that occurred most recently
You can also prefix this, last, and next with a day of the week, month, and special days or holidays. For example, you can use:
  • show sales from last Tuesday to this Tuesday
  • sales from last Halloween to this Christmas

When you prefix this with a day of the week, the Assistant returns the day of the current week, with Sunday being the start. For example, if today is Monday, this Sunday returns the Sunday that just passed. Last Sunday also returns the Sunday that just passed.

Note: You cannot mix holidays or special days with months or days of the week when you use this, last, or next. For example, the Assistant does not support the use of show sales from last Tuesday to next Christmas Day.

For more information, see Assistant filtering.