Dates Filter Options
The FILTERS feature enables you to customize your view of the dashboard and reports data with the Dates filter options being your first and most important query selections.
Since Realize Reports pulls some data nightly, reports you run today may only include data up through the previous day.
Date qualifiers | Date values |
---|---|
is in the last |
Enter a number that represents the amount of time for the filter, and then select a unit of time:
The seconds, minutes, hours, complete seconds, complete minutes, and complete hours options are not recommended. |
is on the day | Select a date on the calendar or enter a date in YYYY–MM–DD format. |
is in the range |
If you want your report to include today's data, select tomorrow's date as the ending date. |
is before |
This filter considers one school year of data (beginning August 1st).
For example, if you select 2019-09-28, you will receive data from August 1, 2019 through September 27, 2019. |
is on or after |
To filter data starting on a specific date and after:
To filter data by units of time:
The hours ago, minutes ago, seconds ago, now, seconds from now, minutes from now, hours from now, days from now, months from now, quarters from now, and years from now options are not recommended. |
is in the year |
This filter considers one calendar year of data. Enter a year in YYYY format. |
is null |
This filter option is not recommended. |
is any time |
This filter provides the data from a complete school year (beginning August 1st) through yesterday. For example, if you choose is any time on March 5, 2020, the report would include data from August 1, 2019 through March 4, 2020. |
is not null |
This filter provides the data from a complete school year (beginning August 1st) through yesterday. For example, if you choose is any time on March 5, 2020, the report would include data from August 1, 2019 through March 4, 2020. |
matches a user attribute | This filter option is not recommended. |
matches advanced | This filter option is not recommended. |
See Also