Its Roadmap view conveniently order milestones by due date. However, the custom report queries it comes with order milestones by their name. Frankly, that’s much less useful. I understand that they are replacing the SQL-driven custom reports with a customizable GUI interface, but in the meantime here’s how you can fix the issue:
- Go to Edit Report
- Insert this clause after any FROMs and before any ORDER BYs:
LEFT JOIN milestone m ON m.name = t.milestone
- Prefix any ambiguous column names with a
dueas the first column in the ORDER BY list
The report will now sort by milestone due date while allowing for empty milestones.