Gantt Charts

Gantt charts show project tasks and their dependencies, and optionally, the critical path.

img-042

Query
Requirements		 Column 1: Text - Task ID
Column 2: Text - Task Name
Column 3: Text - Resource ID (or null or an empty string)
Column 4: Numeric - Start Date as a Unix Timestamp (or 0)
Column 5: Numeric - End Date as a Unix Timestamp (or 0)
Column 6: Numeric - Duration in milliseconds (or 0)
Column 7: Numeric - Percentage complete
Column 8: Text - Dependencies as a comma separated list of Task ID's (or null or an empty string)

The query must return eight columns. Some columns may be omitted by specifying 0, null, or an empty string. At least two of columns 4, 5 and 6 must be specified.
Multiple Plots No
Axis Overrides No
Data Formatting No
Extra Columns No

The Dependencies column must not include any references to non-existent Task ID's. Any such references will result in a red 'error' message instead of a chart. Tasks that have no dependencies should specify the Dependencies column as null or an empty string. Space (' ') is also accepted as a null dependency.