We use Timeline + Numeric Combo (Project duration + Duration) Column to feed a gant chart for scheduling purposes and it works great. what id like to do now is in a chart view is have the ability to sort the amount of duration days per technician that appear within in a certain window of time example January of 2026 only. What im finding is when you filter by Timeline(project duration) there is no ability to filter by “between 2 dates”. does anyone have a work around for this?
You’re right: Chart View doesn’t let you “filter Timeline between two dates.” A couple solid workarounds:
Option A (best for true “days in window”): Workload View/Widget
Add a Workload view (or Dashboard Workload widget).
People = your Technician column; Time = your Timeline; Effort = your Duration (days) number column.
Set Zoom to Month and pick January 2026 in the time picker.
It prorates the effort across the timeline, so you’ll see the exact duration days per tech that fall inside Jan 2026 (even if items span months). You can show totals per person and export if needed.
Option B (precise with Chart View using a helper window)
Add two Date columns: Window Start and Window End (set to 2026‑01‑01 and 2026‑01‑31).
Add a Formula column Overlap Days to calculate how many days of each item’s Timeline fall inside that window:
IF(
OR(EMPTY({Timeline}), EMPTY({Window Start}), EMPTY({Window End})),
0,
MAX(
0,
DAYS(MIN({Timeline#End}, {Window End}), MAX({Timeline#Start}, {Window Start})) + 1
)
)
In Chart View: X-axis = Technician, Y-axis = Sum of Overlap Days. Filter items where Overlap Days > 0. Sort by value to rank techs.
Option C (quick, but not prorated)
Use a Dashboard + Chart widget with the dashboard’s Date filter set to Jan 2026. It will include items overlapping that month, but it won’t clip the duration to the window (it sums the full number).
If you need accurate “days inside the month,” go with Workload. If you need a bar chart you can share/export, the Formula + Chart route works great.
