# Gantt chart

The Gantt chart gives you a time-based view of your projects and tasks; What tasks are planned and when are they to be executed. In the Gantt chart you can also see dependencies between tasks and who is assigned to a task.

A Gantt chart allows you to see at a glance:

* Project start and end dates
* Task start and end dates
* What the task is
* Who is assigned to the task
* If tasks overlap
* Dependencies between tasks

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6I1ZhnUiAS4qGTVR%2Fhelp_root_clients_portal_portlets_Gantt_portletGantt.jpg?alt=media\&token=da582750-ac7d-4664-8b63-7025433b6157)

## Basic Data

**Internal name** - unique string to identify this portlet.

**Portlet title** - title of the portlet, does not have to be unique.

**Checkbox options**

* **Enable header** - enables the portlet header, ie makes it visible in the portal. It is possible select a header background color by clicking on one of the color in the color palette, remove the color by pressing the X underneath the palette
* **Header background color** - select a header background color by clicking on one of the color in the color palette, remove the color by pressing the X underneath the palette
* **Header color text** - select a header text color by clicking on one of the color in the color palette, remove the color by pressing the X underneath the palette
* **Show work days** - tick the box to show only work days in the Gantt chart. Work days are Monday to Friday.
* **Show work hours** - tick the box to show only work hours in the Gantt chart. Work hours are 08:00 - 17:00.
* **Show task selector** - tick the box to enable a drop-down box where it is possible to search for tasks

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6MLgN4mZOGkULUZC%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttBasic.jpg?alt=media\&token=772917ba-7139-4851-9138-c6f5be9482b0)

**Height** - sets the height of the activity display window

**List Width** - sets the width of the activity navigator list&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6OQDaLKXus0bbT5U%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttBasic2.jpg?alt=media\&token=f305be45-0f25-49b8-86a9-2901c51c43bc)

## Auto Refresh

**Auto Refresh** - enables the portlet to refresh the data every SS:second. If data has changed in the columns the table wont refresh until the changes are saved or canceled.&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6Ql05Uo0stH20g8S%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttAutorefresh.jpg?alt=media\&token=84e89e89-0b72-411e-8ebd-e2b10cdf954d)

## Self-Hosting Flows

**Self-Hosting Flows** - enables the portlet to continue running when the user reaches for another portlet.&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6SxusiUjfNNK_5Ny%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttSelfhost.jpg?alt=media\&token=0b883194-e902-4f44-9f4e-0e036ed18701)

## Commands

**The portlet will listen to the following portlets** _Specify which portlet the commands above will trigger from._ The portlets that appears will be shown with their unique internal name.

## Data Source configuration

Data source configuration enables the portlet to execute a specified query towards the chosen database connector to fetch data, or fetch data from a workflow.

**Fetching data using database query**

Data source configuration enables the portlet to execute a specific query to the chosen database connector.

* **Database connector** - Select which connector that the query should execute against
* **Your query** - Text field where queries can be written

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6VYAsbneDPkdZcis%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource.jpg?alt=media\&token=92ff94bc-286a-4dca-a213-ae009e122e8e)

**Fetching data using workflows**

It is possible to use workflows to fetch data.

Read more about Workflow Source in: [Workflow source](../table/workflow-source).&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6X_mnBVXr09rvkoR%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource2.jpg?alt=media\&token=fba49c89-9aa8-413b-9815-00c8cbf6a932)

**Checkbox option**

* **Calculate summery task** - When enabled nullable start date. end date and summery columns will be populated based on task child tasks (Parent id column)

Map the data columns that are to be displayed in the portlet.

* **Task identity column** - The mandatory unique identifier of the task
* **Title column** - The task title that is to be displayed
* **Start date column** - The date the Gantt task starts
* **End date column** - The date the Gantt task ends
* **Parent id column** - The id of the parent task. Required for child tasks
* **Order column** - The position of the task relative to its sibling tasks
* **Is summery column** - If set to true, the task has child tasks
* **Percent column** - The task percentage of completion

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u6ZWLQgNgyX1oN329%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource3.jpg?alt=media\&token=78cf1a48-5691-4827-a7c9-a05e9ba71ae0)

### &#x20;**Dependencies**

In the tab Dependencies it is possible to enter a query or workflow to define the dependencies between tasks.

* **Dependency identity column** - The mandatory unique identifier of the dependency
* **Predecessor identity column** - The mandatory id of the predecessor task
* **Successor identity column** - The mandatory id of the successor task
* **Type column** - The type of dependency. The type is a value between 0 and 3, representing the four different dependency types:
  * 0 - Finish-Finish
  * 1 - Finish-Start
  * 2 - Start-Finish
  * 3 - Start-Start

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7582ZSrcXYNAfEBG%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource4.jpg?alt=media\&token=ab75046b-bb65-4d75-a008-f1a34ac58fba)

A dependency relationship between tasks is indicated by an arrow, as shown in the picture below. If the parent or child task is moved in the Gantt charge, the dependent task will follow accordingly.&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u78Oj3ENJDSyZbfv1%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource5.jpg?alt=media\&token=42bb2252-dad0-4015-b4d6-36d49fb5e474)

### **Resources**

The Resources tab fetches the list of employees, resources, that will be assigned to the task in the Gantt chart.

* **Resource identity column** - The mandatory unique identifier of the resource
* **Title column** - The title of the resource

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7AYtmyUJbsJkrN2a%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource6.jpg?alt=media\&token=4b115b99-d0d0-4e56-abfb-cd230eeb007a)

### **Assignment**

The Assignment is the information which task is assigned to which resource (based on data provided in Task data source and Resources data source).

* **Assignment identity column** - The mandatory unique identifier of the assignment
* **Task identity column** - The mandatory unique identifier of the task
* **Resource identity column** - The mandatory unique identifier of the resource
* **Unit column** - Describes how much of each resource is taken up by the current task

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7DxvEOOmB9BGe7vw%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttDatasource7.jpg?alt=media\&token=e1cc90a7-7f49-4ad5-bf0b-107cd43b972c)

## Flow Configuration

See Flow Configuration in [Table Portlet](../table).&#x20;

## Column Configuration

In column configuration the column which are to be displayed in the Gantt chart are added. It is possible to change the column order by using the up and down arrows. Us the Add button to add rows, the X on row level to remove.&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7Q7uCu57JhQR_UNq%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttColumn.jpg?alt=media\&token=82e6c5d1-0a23-4fc8-a47f-501f8ca3e24b)

The columns will be shown in the same order as in the configuration:&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7SZUr9s5mUKJvqK5%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttColumn2.jpg?alt=media\&token=73cdf8c5-f72e-40fe-85e3-aa94f5ae7464)

### Task Icon Configuration <a href="#task-icon-configuration" id="task-icon-configuration"></a>

It is possible to display icons on the activities in the Gantt chart.

**Default Icon** - field where a default icon value can be added.

**Icon rules** - add a row here to enter icons with conditions. It is possible to enter multiple conditions. The first condition that an activity fulfills is the icon that will be displayed on the activity. Us the Add button to add rows, the X on row level to remove.&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7Whe93Nbm1JckYJb%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttIcon.jpg?alt=media\&token=e0457827-90b2-493f-9050-7ecf10fe2ba9)

The icon Bug shown on a task in the Gantt chart:&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7Z7Ckpq30Pwl-r9I%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttIcon2.jpg?alt=media\&token=b77f457c-7b3e-4f9d-8f6c-4e3470275734)

### Task Color Configuration <a href="#task-color-configuration" id="task-color-configuration"></a>

Activates in the Gantt can be configured in to be displayed different colors. Us the Add button to add rows, the X on row level to remove.

Color rule setup:

* First value - variable.
* Func - parameter to consider.
* Second Value - the value to be measured against the variable.

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7anAqdonl6rqy5U_%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttColor.jpg?alt=media\&token=def115b4-7988-4bcb-89e3-11c15684138c)

### Task Tooltip Configuration <a href="#task-tooltip-configuration" id="task-tooltip-configuration"></a>

In tooltip configuration enter the text and the variables that are to be seen in the Gantt tool tip when the cursor hovers above an activity.

**Fields** - add the columns where the data mapper is required, for example remove the time stamp when a date is displayed

**Tooltip** - add the text and variables, using {}, which are to be displayed&#x20;

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7deVMSsxAbmMs94E%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttTooltip.jpg?alt=media\&token=6245195f-be1b-4781-8c35-d8ce747352b4)

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u5P_Lrk0TIzGf__Rz%2F-M-u7gx5_dxNdh7ThTcB%2Fhelp_root_clients_portal_portlets_Gantt_portletGanttTooltip2.jpg?alt=media\&token=f92c42c5-01bf-4afd-950c-9cb6334d8442)
