Hello.
Is there a way for me to have multiple baselines on a gantt chart....
select 'dbr.chart','gantt';
select 'dbr.chart.options', 'gantt.dateline', now();
select 'dbr.chart.options','gantt.baseline',pe.name, planned_start, planned_end
from shifts s
inner join employees pe on s.planned_employee = pe.id
where planned_start between inDate and DATE_ADD(inDate, INTERVAL 1 DAY);
select 'dbr.chart.options','gantt.baseline_pattern.color', '0x1B32C4'; /* Switch to new color for orders - overlaying the baseline above (but shorter intervals) */
select 'dbr.chart.options','gantt.baseline',driver, received_time, delivered_time
from order_data
where received_time between inDate and DATE_ADD(inDate, INTERVAL 1 DAY)
order by driver, received_time;
select pe.name, clock_in, ifnull(clock_out, GREATEST( planned_end, least(now(), addtime(now(), '23:59:59')))), 'actual'
from shifts s
inner join salaries.employees pe on s.actual_employee = pe.id
where planned_start between inDate and DATE_ADD(inDate, INTERVAL 1 DAY)
and clock_in is not null;
I would like the gantt chart, with 0 to many shifts as the gantt bars, 1 to many shifts on the first baseline, and then short baselines in dark blue showing the time the orders are with drivers.
