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 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:

 

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 1 Likes
  • 1 yr agoLast active
  • 505Views
  • 1 Following