As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

TIBCO Spotfire® Tips&Tricks - How to create a Gantt Chart Visualization

Last updated:
1:44am Nov 08, 2021

 

Gantt chart is now available as a visualization mod for TIBCO Spotfire® available to download from the TIBCO Community Exchange.

To use the Gantt Chart Mod, TIBCO Spotfire® 11.4 or later is required.

Introduction

A Gantt chart is a graphical representation of the tasks or activities along with resources required to complete a job or project. It is used to show ranges of start and end dates of activities or tasks and the relationships between them so as to pinpoint bottlenecks and assign priorities. Gantt charts started as laborious hand-made charts in the mid 1890s, popular during world war I and still quite useful for project management and scheduling. Depending on what you want to visualize in the Gantt chart, and what the data looks like, you may be able to create the chart right away, or some intermediate steps may be required. Let’s start with a basic example.

Data Preparation

TIBCO Spotfire® has wide range of functionality to help get data into a format appropriate for analysis. In this example we will use a data table, which has information about various activities start time, end time, duration, and resources responsible for completing the activity. The entire Project completes in three phases and each phase requires the previous phase to be completed.

Data

Loading Data

You can directly open a CSV file both from cloud as well as from Spotfire Analyst. Spotfire allows to you to bring in data from multiple sources.

Create a Gantt chart in Spotfire in 4 easy steps

Step 1: Insert a Scatter Plot and change the X-axis to week no. or any date column you want to use

Step 1

Step 2: Change Y-axis – Phase as first level of hierarchy, next Activity and third Type. Make sure you check reverse scale. Spotfire allows you to create a hierarchy in multiple ways.

Step 2

Step 3: Select Type as color by and task_status as Shape. This will help you identify when a planned or actual activity started and when it finished.

Step 4: Use Line connection to draw a separate line for each activity and type. Each activity has a start and end row in the data, and that's how the lines are drawn from start to end

Step 4

You have your Gantt chart ready.  You can add a line to indicate the current date and even add custom themes to make it look pretty.

Gantt Chart

Attachments

AttachmentSize
Package icon gantt_chart.zip162.94 KB

Feedback (4)

The Gantt presentation of data is quite useful!

Has anyone now an idea, how to visualize cascading relationships (meaning a line connection between the endpoint of a predecessor tasks and the next task)?

arno.stoehr 11:58pm Dec. 04, 2017

Thank you, good stuffs! How did you change the format of the marker to "no fill" with line?

dawnduong 11:49pm Dec. 26, 2016

Hi,

Thanks for the detailed instructions. I have put together a Gantt chart in this way, but would like to be able to select on the line connection between points and drill down further. Does anybody have any ideas of how this might be done?

Thanks

AS2301 4:19am Sep. 18, 2016

good stuff !! 

Michael OConnell 5:54pm May. 27, 2016