Gantt Chart - Revision history

Ollvihe: /* Gantt chart features */

2023-05-31T22:28:08Z

Gantt chart features

← Older revision		Revision as of 22:28, 31 May 2023
Line 3:		Line 3:
	==Gantt chart features==		==Gantt chart features==
	Gantt chart has the following features:		Gantt chart has the following features:
	* ~~Items~~ with zero duration ~~can be visualized~~ (i.e., start time is same as ~~the~~ end time, or the end time is not defined)~~. These items are shown as the milestone diamonds~~.		* There is a milestone diamond for items with zero duration (i.e., start time is same as end time, or the end time is not defined).
	* ~~The gantt~~ chart is able to visualize the dependencies between items by drawing arrows between them. This requires a unique id ~~for each item~~ and the predecessor item id to be defined.		* Gantt chart is able to visualize the dependencies between items by drawing arrows between them. This requires the unique id and the predecessor item id to be defined.
	* ~~The gantt~~ chart is able to show the swimlanes in a hierarchy. This requires a unique id ~~for each item~~ and the parent id to be defined.		* Gantt chart is able to show the swimlanes in a hierarchy. This requires the unique id and the parent id to be defined.
			* Additional properties for the swimlane items can be shown in the table left side of the gantt chart. There can be as many columns as needed.
			* Completion percentage for each item can be shown. Left side of the item is darker showing a bar inside the item.
	* Filters can be created in the gantt chart by clicking one or several items.		* Filters can be created in the gantt chart by clicking one or several items.
	* ~~The gantt~~ chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the mouse button pressed).		* Gantt chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the left mouse button pressed).
	* ~~Current~~ time indicator is shown.		* The vertical line as the current point of time indicator is shown (assuming time data for future is provided to the chart).

	[[File:Gantt.png]]		[[File:Gantt.png]]

	==Gantt chart mappings==		==Gantt chart mappings==
	The features in the gantt chart are activated by ~~taking into use the different~~ mappings ~~available~~. The ~~mappings~~ settings can be found in the measure, dimension or column settings. Gantt chart has the following mappings:		The features in the gantt chart are activated by using available mappings. The mapping settings can be found in the [[Measure, Dimension and Column Settings\|measure, dimension or column settings dialog]]. Gantt chart has the following mappings:
	* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. ~~This~~ mapping is mandatory.		* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. The swimlane mapping is mandatory.
	* '''Start time''': Start time of the item. ~~This~~ mapping is mandatory.		* '''Start time''': Start time of the item. The start time mapping is mandatory.
	* '''End time''': End time of the item. If the end time is not ~~mapped~~ or contains a null value, the item is shown as a milestone diamond~~. This mapping is optional~~.		* '''End time''': End time of the item. If the end time is not defined or contains a null value, the item is shown as the milestone diamond.
	* '''Table column''': Data mapped as ''Table column'' is shown as a table, left side of the gantt chart. There can be several ~~of the~~ table column mappings, each appearing as separate columns.		* '''Table column''': Data mapped as ''Table column'' is shown as a table left side of the gantt chart. There can be several table column mappings, each appearing as separate columns.
	* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.		* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.
	* '''Item id''': Technical id for the items, defining the item id for parents and predecessors. If this mapping is not defined, the ~~swimlane~~ mapping is used as the item id.		* '''Item id''': Technical id for the items, defining the item id for parents and predecessors. If this mapping is not defined, the ''Swimlane name'' mapping is used as the item id.
	* '''Parent id''': Defines the parent for each item. Refers to the ''Item id'' (if defined) or ''~~swimlane~~'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy.		* '''Parent id''': Defines the parent for each item. Refers to the ''Item id'' (if defined) or ''Swimlane'' ''name'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy.
	* '''Predecessor id''': Defines the predecessor (dependency) for an item. Refers to the ''Item id'' (if defined) or ''~~swimlane~~'' of the predecessor item. The predecessors are shown as arrows.		* '''Predecessor id''': Defines the predecessor (dependency) for an item. Refers to the ''Item id'' (if defined) or ''Swimlane name'' of the predecessor item. The predecessors are shown as arrows.
	* '''Show in tooltip''': Data is shown in the tooltip which is the box appearing when an item is hovered with the mouse.		* '''Show in tooltip''': Data is shown in the tooltip which is the box appearing when an item is hovered with the mouse. Multiple of these type of mappings can be provided.
	* '''Show in datalabel''': Data is shown ~~on top of~~ the item in the gantt chart.		* '''Show in datalabel''': Data is shown over the item in the gantt chart. Multiple of these type of mappings can be provided.
	* '''Color''': Defines ~~how the~~ items are colored~~. Each~~ item with the same value will get the same color.		* '''Color''': Defines that items are colored based on this data, so each item with the same value will get the same color. Note that this mapping is not for directly providing the color code, but the colors are coming from the color palette.

	==Colors and conditional formatting==		==Colors and conditional formatting==
	Items in the gantt chart get colors from the color palette (available in the chart settings), when the ''Color'' mapping nor the conditional formatting are defined. The ''Color'' mapping is an easy way to show which items have the same value for the ~~measure/dimension/column~~ mapped ~~to the ''Color''~~. The most advanced method is to use the [[#Conditional_formatting\|conditional formatting]] which ~~freely defines~~ the color ~~for each items~~.		Items in the gantt chart get colors from the color palette (available in the chart settings), when neither the ''Color'' mapping nor the conditional formatting are defined. The ''Color'' mapping is an easy way to show which items have the same value for the mapped data. The most advanced method to define colors is to use the [[#Conditional_formatting\|conditional formatting]] which has different logics available to define the colors, such as traffic lights or color scales.

	~~Conditional formatting can be used to define gantt item colors flexibly.~~ The conditional formatting json needs to be defined to the measure/dimension/column that is mapped to the ''swimlane''.		The conditional formatting json needs to be defined to the measure/dimension/column that is mapped to the ''swimlane name''.

	Traffic lights colors based on a numerical values:		Example: Traffic lights colors based on a numerical values:
	<pre>		<pre>
	{		{
Line 54:		Line 56:
	</pre>		</pre>

	Color scale based on a numerical values defined in the 4th column:		Example: Color scale based on a numerical values defined in the 4th column:
	<pre>		<pre>
	{		{
Line 80:		Line 82:
	</pre>		</pre>

	Color code coming from a column:		Example: Color hexadecimal code coming from the 4th column (using some kind of custom expression):
	<pre>		<pre>
	{		{

Ollvihe at 22:05, 31 May 2023

2023-05-31T22:05:27Z

← Older revision		Revision as of 22:05, 31 May 2023
Line 9:		Line 9:
	* The gantt chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the mouse button pressed).		* The gantt chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the mouse button pressed).
	* Current time indicator is shown.		* Current time indicator is shown.

			[[File:Gantt.png]]

	==Gantt chart mappings==		==Gantt chart mappings==

Ollvihe at 22:03, 31 May 2023

2023-05-31T22:03:58Z

← Older revision		Revision as of 22:03, 31 May 2023
Line 1:		Line 1:
	Gantt chart is mostly used for illustrating project ~~schedules~~ and ~~project~~ breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases ~~go in relation to~~ each other. The gantt chart has the calendar time axis ~~horizontally~~ and swimlanes ~~vertically~~.		Gantt chart is mostly used for illustrating project schedule and breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how events in multiple cases interact or coincide with each other. The gantt chart has the horizontal calendar time axis and vertically it shows ''swimlanes''.

	==~~Overview~~==		==Gantt chart features==
	Gantt chart has the following features:		Gantt chart has the following features:
	* Items with zero duration can be visualized (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.		* Items with zero duration can be visualized (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.
Line 10:		Line 10:
	* Current time indicator is shown.		* Current time indicator is shown.

	==~~Mappings~~==		==Gantt chart mappings==
	The features in the gantt chart are activated by taking into use the different mappings available. The mappings settings can be found in the measure, dimension or column settings. Gantt chart has the following mappings:		The features in the gantt chart are activated by taking into use the different mappings available. The mappings settings can be found in the measure, dimension or column settings. Gantt chart has the following mappings:
	* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. This mapping is mandatory.		* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. This mapping is mandatory.

Ollvihe at 21:53, 31 May 2023

2023-05-31T21:53:25Z

← Older revision		Revision as of 21:53, 31 May 2023
Line 1:		Line 1:
	Gantt chart is ~~typically~~ used for illustrating project schedules and project breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases go in relation to each other. The gantt chart has the calendar time axis horizontally and swimlanes vertically.		Gantt chart is mostly used for illustrating project schedules and project breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases go in relation to each other. The gantt chart has the calendar time axis horizontally and swimlanes vertically.

	==Overview==		==Overview==

Ollvihe: /* Mappings */

2023-05-31T11:59:11Z

Mappings

← Older revision		Revision as of 11:59, 31 May 2023
Line 15:		Line 15:
	* '''Start time''': Start time of the item. This mapping is mandatory.		* '''Start time''': Start time of the item. This mapping is mandatory.
	* '''End time''': End time of the item. If the end time is not mapped or contains a null value, the item is shown as a milestone diamond. This mapping is optional.		* '''End time''': End time of the item. If the end time is not mapped or contains a null value, the item is shown as a milestone diamond. This mapping is optional.
	* '''Table column''': Data is shown as a table, left side of the gantt chart. There can be several of the table column mappings, each appearing as separate columns. When the table column mapping are not in use, the swimlane name is shown as a column, left side of the gantt chart. When the table column mapping are use, only the data mapped as table columns are shown as columns.		* '''Table column''': Data mapped as ''Table column'' is shown as a table, left side of the gantt chart. There can be several of the table column mappings, each appearing as separate columns.
	* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.		* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.
	* '''Item id''': Technical id for the items, defining the item id for parents and predecessors. If this mapping is not defined, the swimlane mapping is used as the item id.		* '''Item id''': Technical id for the items, defining the item id for parents and predecessors. If this mapping is not defined, the swimlane mapping is used as the item id.

Ollvihe: /* Mappings */

2023-05-30T13:24:47Z

Mappings

← Older revision		Revision as of 13:24, 30 May 2023
Line 17:		Line 17:
	* '''Table column''': Data is shown as a table, left side of the gantt chart. There can be several of the table column mappings, each appearing as separate columns. When the table column mapping are not in use, the swimlane name is shown as a column, left side of the gantt chart. When the table column mapping are use, only the data mapped as table columns are shown as columns.		* '''Table column''': Data is shown as a table, left side of the gantt chart. There can be several of the table column mappings, each appearing as separate columns. When the table column mapping are not in use, the swimlane name is shown as a column, left side of the gantt chart. When the table column mapping are use, only the data mapped as table columns are shown as columns.
	* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.		* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.
	* '''Item id''': Technical id for the items, ~~needed when~~ defining parents and predecessors.		* '''Item id''': Technical id for the items, defining the item id for parents and predecessors. If this mapping is not defined, the swimlane mapping is used as the item id.
	* '''Parent id''': Defines the parent ~~item~~ for each ~~time~~. Refers to the ''Item id'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy~~. When this mapping is defined, also the ''Item id'' mapping is needed~~.		* '''Parent id''': Defines the parent for each item. Refers to the ''Item id'' (if defined) or ''swimlane'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy.
	* '''Predecessor id''': Defines ~~from which other item,~~ the item ~~is dependant~~. ~~The dependencies are shown as arrows in the gantt chart. When this mapping is defined, also~~ the ''Item id'' ~~mapping is needed~~.		* '''Predecessor id''': Defines the predecessor (dependency) for an item. Refers to the ''Item id'' (if defined) or ''swimlane'' of the predecessor item. The predecessors are shown as arrows.
	* '''Show in tooltip''': ~~Information~~ is shown in the tooltip which is the box appearing when an item is hovered with the mouse.		* '''Show in tooltip''': Data is shown in the tooltip which is the box appearing when an item is hovered with the mouse.
	* '''Show in datalabel''': ~~Information~~ is shown on top of the item in the gantt chart.		* '''Show in datalabel''': Data is shown on top of the item in the gantt chart.
	* '''Color''': Defines how the items are colored. Each item with the same value will get the same color.		* '''Color''': Defines how the items are colored. Each item with the same value will get the same color.

Ollvihe: /* Mappings */

2023-05-30T11:30:07Z

Mappings

Ollvihe at 11:21, 30 May 2023

2023-05-30T11:21:50Z

← Older revision		Revision as of 11:21, 30 May 2023
Line 1:		Line 1:
	Gantt chart is typically used for illustrating project ~~schedule~~ and breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases go in relation to each other. The gantt chart has the calendar time axis horizontally and swimlanes vertically.		Gantt chart is typically used for illustrating project schedules and project breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases go in relation to each other. The gantt chart has the calendar time axis horizontally and swimlanes vertically.

	==Overview==		==Overview==

Ollvihe: /* Mappings */

2023-05-30T11:21:12Z

Mappings

← Older revision		Revision as of 11:21, 30 May 2023
Line 11:		Line 11:

	==Mappings==		==Mappings==
	Gantt chart has the following mappings:		The features in the gantt chart are activated by taking into use the different mappings available. The mappings settings can be found in the measure, dimension or column settings. Gantt chart has the following mappings:
	* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. This mapping is mandatory.		* '''Swimlane name''': Swimlane where the item belongs to. Swimlane names are unique, so if there are several items with the same name, they go to the same swimlane. This mapping is mandatory.
	* '''Start time''': Start time of the item. This mapping is mandatory.		* '''Start time''': Start time of the item. This mapping is mandatory.

Ollvihe at 08:23, 30 May 2023

2023-05-30T08:23:53Z

← Older revision		Revision as of 08:23, 30 May 2023
Line 1:		Line 1:
	Gantt chart has the calendar time axis horizontally and swimlanes vertically.		Gantt chart is typically used for illustrating project schedule and breakdown into tasks, but in process mining gantt chart can also be used to visualize events in an individual case, or how multiple cases go in relation to each other. The gantt chart has the calendar time axis horizontally and swimlanes vertically.

	==Overview==		==Overview==
	The gantt chart is able to visualize ~~also~~ items where the duration is zero (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.		Gantt chart has the following features:
			* The gantt chart is able to visualize items where the duration is zero (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.
	The gantt chart is able to visualize the dependencies between items by drawing arrows between them. This requires a unique id for each item and the dependant item to be defined.		* The gantt chart is able to visualize the dependencies between items by drawing arrows between them. This requires a unique id for each item and the dependant item to be defined.
			* The gantt chart is able to show the swimlanes in a hierarchy. This requires a unique id for each item and the parent id to be defined.
	The gantt chart is able to show the swimlanes in a hierarchy. This requires a unique id for each item and the parent id to be defined.		* Filters can be created in the gantt chart by clicking one or several items.
			* The gantt chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the mouse button pressed).
	Filters can be created in the gantt chart by clicking one or several items.		* Current time indicator is shown.

	The gantt chart can be zoomed using the lasso tool (move the mouse in the gantt chart while keeping the mouse button pressed).

	Current time indicator is shown.

	Items in the gantt chart get colors from the color palette (available in the chart settings), when the ''Color'' mapping nor the conditional formatting are defined. The ''Color'' mapping is an easy way to show which items have the same value for the measure/dimension/column mapped to the ''Color''. The most advanced method is to use the [[#Conditional_formatting\|conditional formatting]] which freely defines the color for each items..

	==Mappings==		==Mappings==
Line 30:		Line 24:
	* '''Color''': Defines how the items are colored. Each item with the same value will get the same color.		* '''Color''': Defines how the items are colored. Each item with the same value will get the same color.

	==~~Conditional~~ formatting==		==Colors and conditional formatting==
			Items in the gantt chart get colors from the color palette (available in the chart settings), when the ''Color'' mapping nor the conditional formatting are defined. The ''Color'' mapping is an easy way to show which items have the same value for the measure/dimension/column mapped to the ''Color''. The most advanced method is to use the [[#Conditional_formatting\|conditional formatting]] which freely defines the color for each items.

	Conditional formatting can be used to define gantt item colors flexibly. The conditional formatting json needs to be defined to the measure/dimension/column that is mapped to the ''swimlane''.		Conditional formatting can be used to define gantt item colors flexibly. The conditional formatting json needs to be defined to the measure/dimension/column that is mapped to the ''swimlane''.

← Older revision		Revision as of 11:30, 30 May 2023
Line 3:		Line 3:
	==Overview==		==Overview==
	Gantt chart has the following features:		Gantt chart has the following features:
	* ~~The gantt chart is able to visualize items where the~~ duration ~~is zero~~ (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.		* Items with zero duration can be visualized (i.e., start time is same as the end time, or the end time is not defined). These items are shown as the milestone diamonds.
	* The gantt chart is able to visualize the dependencies between items by drawing arrows between them. This requires a unique id for each item and the ~~dependant~~ item to be defined.		* The gantt chart is able to visualize the dependencies between items by drawing arrows between them. This requires a unique id for each item and the predecessor item id to be defined.
	* The gantt chart is able to show the swimlanes in a hierarchy. This requires a unique id for each item and the parent id to be defined.		* The gantt chart is able to show the swimlanes in a hierarchy. This requires a unique id for each item and the parent id to be defined.
	* Filters can be created in the gantt chart by clicking one or several items.		* Filters can be created in the gantt chart by clicking one or several items.
Line 15:		Line 15:
	* '''Start time''': Start time of the item. This mapping is mandatory.		* '''Start time''': Start time of the item. This mapping is mandatory.
	* '''End time''': End time of the item. If the end time is not mapped or contains a null value, the item is shown as a milestone diamond. This mapping is optional.		* '''End time''': End time of the item. If the end time is not mapped or contains a null value, the item is shown as a milestone diamond. This mapping is optional.
	* '''Table column''': ~~Information~~ is shown as a table, left side of the gantt chart. There can be several of ~~these~~ mappings.		* '''Table column''': Data is shown as a table, left side of the gantt chart. There can be several of the table column mappings, each appearing as separate columns. When the table column mapping are not in use, the swimlane name is shown as a column, left side of the gantt chart. When the table column mapping are use, only the data mapped as table columns are shown as columns.
	* '''Completion percentage''': ~~Optionally, gantt~~ chart ~~is able~~ to show ~~visually~~ the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100.		* '''Completion percentage''': Gantt chart can to show the completion percentage for each item. The completion percentage needs to be provided as a percentage value between 0 and 100. This mapping is optional.
	* '''Item id''': Technical id for the items~~. This is~~ needed when defining parents and ~~dependencies~~.		* '''Item id''': Technical id for the items, needed when defining parents and predecessors.
	* '''Parent ~~item~~ id''': Defines the parent item for each time. Refers to the ''Item id'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy. When this mapping is defined, also the ''Item id'' mapping is needed.		* '''Parent id''': Defines the parent item for each time. Refers to the ''Item id'' of the parent. When this mapping is defined, the swimlanes are shown in a hierachy. When this mapping is defined, also the ''Item id'' mapping is needed.
	* '''~~Dependant on item~~ id''': Defines from which other item, the item is dependant. The dependencies are shown as arrows in the gantt chart. When this mapping is defined, also the ''Item id'' mapping is needed.		* '''Predecessor id''': Defines from which other item, the item is dependant. The dependencies are shown as arrows in the gantt chart. When this mapping is defined, also the ''Item id'' mapping is needed.
	* '''Show in tooltip''': Information is shown in the tooltip which is the box appearing when an item is hovered with the mouse.		* '''Show in tooltip''': Information is shown in the tooltip which is the box appearing when an item is hovered with the mouse.
	* '''Show in datalabel''': Information is shown on top of the item in the gantt chart.		* '''Show in datalabel''': Information is shown on top of the item in the gantt chart.