This draft documentation may be incomplete or inaccurate, and is subject to change until this release is generally available (GA).

Date filters for Answers and Liveboards

We have increased the possible range of dates you can use to filter your Answers and Liveboards. Previously, when adding a date using the filter from the side bar, users were limited to the following conditions: On (=) <date>, On or after (>=) <date>, Before (<) <date>, and Between <date> and <date>. Now, we support rolling time windows, as well as fixed date ranges.

For a complete list of the date options ThoughtSpot supports for Answers and Liveboards, see the following options:

  1. Rolling time windows. Note that in this context, s/m/h/D/W/M/Q/Y means seconds/minutes/hours/days/weeks/months/quarters/years.

    • Yesterday

    • Today

    • Tomorrow

    • This s/m/h/D/W/M/Q/Y

    • Last s/m/h/D/W/M/Q/Y

    • Next s/m/h/D/W/M/Q/Y

    • Before this/last/next s/m/h/D/W/M/Q/Y

    • After this/last/next s/m/h/D/W/M/Q/Y

    • On or after this/last/next s/m/h/D/W/M/Q/Y

    • On or before this/last/next s/m/h/D/W/M/Q/Y

    • Week to date e.g. 05/15/2023 < 05/22/2023

    • Month to date e.g. May

    • Quarter to date e.g. 04/01/2023 < 05/22/2023

    • Year to date e.g. 2023

  2. Specific calendar dates or date ranges.

    • Is between

    • Is not in between

    • Is on

    • Is not on

    • Is after

    • Is on or after

    • Is before

    • Is on or before

    • In the month and year e.g. Jan 2020

    • In the quarter and year e.g. Q1 2020

    • In the year e.g. 2020

Was this page helpful?
×