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: