People love to see their schedules. So a Gantt Chart can be a great addition to a dashboard to offer context. Here is a Parameterized Snippet and set of toggles to get a Gantt Chart going with little effort.
Base: Bar Chart
- Horizontal Bar Chart
- Y-axes: start_length, duration
- start_length series color: #f5f6f7
- Tooltips: start_date, end_date
select [phase] , [start_date] , [end_date] , datediff(day, first_date, [start_date]) as start_length , datediff(day, [start_date], [end_date]) as duration from [table], (select min([start_date]) first_date from [table]) as first_date order by [order]
Screenshot with tooltip:
Please sign in to leave a comment.