We support fixed date ranges as well as rolling time windows when adding a date using the filter from the sidebar. This gives more flexibility and control over your data analysis.
For a complete list of the date filtering options available in Trends AI for Charts and Boards, please review the options below:
Rolling Time Windows - Note: in this context, s/m/h/D/W/M/Q/Y refers to seconds, minutes, hours, days, weeks, months, quarters, or years, respectively:
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 (Example: 05/15/2023 < 05/22/2023)
Month to date (Example: May)
Quarter to date (Example: 04/01/2023 < 05/22/2023)
Year to date (Example: 2023)
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 (Example: Jan 2025)
In the quarter and year (Example: Q1 2025)
In the year (Example: 2025)