Gantt Chart Mod for Spotfire®

The Gantt chart is a type of bar chart, that visualizes various categories into time series. Gantt charts illustrate the start and finish time in time period blocks.

Gantt charts are often used in project management as one of the most popular and useful ways of showing activities displayed against time. On the left of the chart is a list of the activities and along the top is a suitable time scale. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity.

Data requirement

Every mod handles missing, corrupted and/or inconsistent data in different ways. It is advised to always review how the data is visualized.

To make the Gantt chart work properly, the underlying data must be formatted in a certain way. A data table with at least three columns is required. At least one column must contain tasks names. A second column must contain start dates for each task. And a third column must contain end dates for each task.

An optional column to show progress (%) may also be used.

Setting up the chart

In this example dataset, we have six columns: project, task, start, end, owner, completion

A Gantt chart can be configured to show the evolution of this project by creating a Gantt chart with the following setting:

• Task = 'step' and 'task'
• Start = 'from' with (First) as aggregation method
• End = 'to' with (first) as aggregation method

Optionally we could also use colors to show task blocks by team and use the completion data to show progress. E.g:

• Color By = 'owner
• Progress = 'completion'

The end result will look something like this:

The chart above shows one period block by step and task colored by responsible teams.

Configuring the chart

The Gantt chart can be configured by setting one or multiple categories of tasks and sub-tasks. Start dates and end dates for each category must be set with aggregation type (First).


Once the Gantt chart is configured and has data provided, you can also highlight overdue tasks or hide weekends. These settings are accessed by clicking on the list of tasks or on the header.

Using the chart

View mode

Switch to show/hide months and days.

Zoom to details

Use the zoom slider to get a closer look at details in your visualization.

Tooltip

Hover a task block to show a tooltip with its name, start date, end date and eventual progression.

Marking

Click a task block to mark it in the Gantt chart and in all other visualizations that use the same marking. Click a parent task to mark all sub-tasks. Click an empty space in between task blocks to clear marking.

Help and support

This Mod for Spotfire® is not supported by Support.
In the event of issues or to suggest features and enhancements, submit an issue in the Mod's GitHub repository. 

For general questions about Mods, please post a question in the Forum for Extensions & Mods to make it visible and routed to the appropriate team(s) to respond.

More information about Mods for Spotfire®

• Spotfire Community Exchange: A safe and trusted place to discover ready-to-use Mods
• Developer Documentation: Introduction and tutorials for Mods developers
• Mods code examples on GitHub: A public repository for example projects