I am trying to use the apex Gantt chart to show visually the days a particular task has been done.
The task name is on the y axis and date on the x-axis
I am using 2 tables, one which logs the dates the event occurred and the other holding details about the task (name etc).
I am able to get it to show me each occurrence as a separate line with a diamond for the day it occurred, If I use the primary key from the first (events dates) table as the task_id. This provides a unique task_id for each row retrieved.
I can then get it to merge all of the same task occurrences on the same line if i use the 2nd table (task details) primary key as the task_id. (this provides each occurrence of the same task with the same task_id, which the gantt chart shows on the same line)
The only problem is that when the gantt merges on to the same line it leaves an empty gap at the top of the chart before the first line displayed (the depth of the number of lines that have been merged).
EXAMPLE:
if 7 records are retrieved and 4 are unique task lines (3 duplicate tasks on different dates)
The Gantt will show me 4 lines (3 lines with 2 diamonds and 1 with a single diamond). It will however have a 3 line empty gap before the first row.
Is there any way of clearing up or working around the empty gap?
I understand that this is not the correct usage of a Gantt chart but almost meets my requirements without too much additional coding.