The Date Range filter surfaces items that have hours logged or scheduled in the time period. This unique approach ensures you always capture the time and effort driving your organization’s priorities. Date Range can be used in Table Reports, applied to Dashboards, Dashboard Groups, and many of the Dashboard Widgets.
1 | Segment and view data by time period |
...
Use a date range filter to segment and view data by time period in reports and dashboards. The criteria pulling rows into a report when a date range filter is applied are hours logged or hours scheduled during the time period.
...
The date range filter works in conjunction with project and task status filters, custom property filters, and the assignment filter. It’s is an optional filter setting for Table Reports, Dashboards, Groups, and Widgets in all Libraries (Workspace, Portfolio, Package, Project).
2 | Columns for date range filtering |
When a date range is applied, the results include items or people with Hours logged and those with Hours scheduled in the time period. Values in those columns reflect what is true for the time period.
...
Total Work Scheduled = hours scheduled during the time period + hours logged during the time period.
3 | Applying a date range |
...
All Dates shows the current state, with a complete roll up of items within the report or widget scope. When a date range is applied, the filtered state changes to include only those items with hours logged or scheduled in the selected time period.
Date Ranges: Custom Date Range, Last Month, This Month, Next Month, Year to date, 3 week window (last week, current week, next week)
Default: All Dates
4 | Hours logged and scheduled by date range |
Date ranges can encompass past dates, future dates, or a span that includes past and future.
...
Past and Future Date Span: results include items with hours logged, and and those with hours scheduled between now and the end of the date range.
5 | Date range filter example for hours logged |
Let’s say a task has 22 hours logged:
...
Below shows the Task’s hours logged column results for All Dates and how it changes by date range.
Date Range | Hours Logged |
|---|---|
All Dates | 22.00h |
January 1 – January 31 | 3.00h |
February 1 – February 28 | 9.00h |
January 15 – February 15 | 12.00h |
6 | Date range in Dashboards |
...
Dashboards, Groups, and many of the widgets can have a date range filter applied. Hover over the calendar icon on a widget to see date ranges driving filter results.
...
Widgets that don’t respond to date filters: Schedule Summary, Workload, Dashboard Note, Linked Note, Image, Project Intake, Task Intake
7 | Date Ranges on the Dashboard, Group, and Widgets combine |
...
Date Ranges can be applied at multiple levels in a dashboard. It’s important to note these are “and” filters that combine to produce results. For example, if a Dashboard is filtered to This Month and one of the widgets is filtered to Last Month, the combined filter results will include items that are scheduled this month that also had hours logged last month.
...