Timeline Charts
Timeline charts are good for showing how resources are used over time. They are perfect for overviews of accommodation or meeting rooms, or for resources on a project.
| Query Requirements |
Column 1: Text - row name Column 2: Text - bar name Column 3: From Date Column 4: To Date The query must return all four columns, the first being the row name, the second being the name of the bar. The third column is the start date and the fourth column is the end date. Dates must be retrieved as Unix Timestamps, i.e. using the UNIX_TIMESTAMP( ) sql function. |
| Multiple Plots |
No Timelines only show a single data series. |
| Axis Overrides |
No The date range is determined by the data. |
| Data Formatting |
No Text is shown as returned by the query. |
| Extra Columns |
Yes tooltip |
Timeline charts don't have a title, and you can't specify data ranges, axis titles, or the date format. You can specify the chart size and background colour.