Home

This Mod for Spotfire® can be used to 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.

Installation

Opening the visualization in Spotfire® Analyst

1. From this repository Releases section, locate and download the .mod file.
2. Drag the .mod file into an analysis in Spotfire® Analyst.

For information on how to use and share visualizations mods, read the Spotfire® documentation.

Running the project in Spotfire®

1. From this repository Releases section, locate and download the source code.
2. Build the project in your preferred code editor. Microsoft Visual Studio Code is highly recommended.
3. Open an analysis in Spotfire® and select Tools > Development > Create visualization mod from the menubar to connect to the project.

For information on how to get started with visualization mod development, read the Spotfire® documentation.

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.

Setup

In this example dataset, we have six columns: step, task, from, to, owner, completion

step	task	from	to	owner	completion
Concept	Groundwork	07/01/2021	07/05/2021	Cross teams	1.0
Concept	MVP definition	07/06/2021	07/06/2021	Product	1.0
Concept	Effort estimation	07/06/2021	07/09/2021	Cross teams	1.0
Development	Back-end	07/12/2021	07/21/2021	Feature	1.0
Development	Models training	07/19/2021	07/30/2021	Data science	1.0
Development	User experience	07/12/2021	07/16/2021	UX	1.0
Development	Front-end	07/19/2021	07/23/2021	Feature	1.0
Development	Technical preview	08/02/2021	08/04/2021	Feature	1.0
Productization	Code review	08/04/2021	08/06/2021	Feature	1.0
Productization	Testing	08/05/2021	08/06/2021	Test	1.0
Productization	Texts and documentation	08/02/2021	08/06/2021	Writers	1.0
Productization	Beta release	08/09/2021	08/10/2021	Feature	1.0
Release	Bug fixes	08/09/2021	08/13/2021	Feature	1.0
Release	Final build	08/16/2021	08/17/2021	Cross teams	0.75
Release	Deployment	08/18/2021	08/19/2021	DevOps	0.0

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'

Configuration

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.

Usage

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.