This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
on - edited on by
DRay
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:
