Chart Type -- Gantt Chart
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
Toggles:
- Horizontal Bar Chart
- Y-axes: start_length, duration
- start_length series color: #f5f6f7
- Tooltips: start_date, end_date
Name: gantt_chart(table,phase,start_date,end_date,order)
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.
Comments
0 comments