Skip to main content

Gantt Chart

The gantt chart report is a report type specifically for showing time-based property values. Examples could be the lifecycle of applications: Planning, PhaseIn, Production, PhaseOut, End of Life. The respective end dates of these phases are saved in properties of the asset.

Concepts​

The assets resolved by the query are displayed on the y-axis. The data on the time-based x-axis is displayed according to the x-axis config. The config defines which property-values are shown for each asset.

Configuration​

  1. Use the query to create custom queries. The y-axis shows all assets which are resolved by the query.
  2. Use the Customize axis menu to select the time-based properties that should be shown on the x-axis.
    • Time ranges can be defined by either a single range property or by choosing a date property for both start and end.
    • Dates are shown when only the start property is set.
    • If the selected property can hold multiple values, each value or pair of values is rendered separately.
    • Properties with non date/time-related data types can not be selected.
  3. Use the Customize axis menu to group the assets from the y-axis by a property or relation to other asset types of your choice (more details below).

The following example shows the configuration for visualizing lifecycle properties of applications:

The resulting gantt chart could look like this:

The labels shown in the legend can be changed in the Customize axis config as well. They default to the name of the defining property but can be overwritten by the user.

Hierarchical y-axis grouping​

The axis configuration also allows grouping of resolved assets on the y-axis by properties or links. The configuration is similar to the property-based clustering of the cluster matrix report.

The following example shows the queried applications grouped by their migration status:

This leads to the following gantt chart:

The resulting categories are shown as an indented list. To indicate where bars are present for one of the contained assets, a special range marker is shown on the x-axis. Clicking on a category in the y-axis or one of the range markers shows the contained assets in the sidebar.

Property-based grouping​

Property-based groupings create a new hierarchy containing all assets with a common value. E.g. by adding a vertical Aspect grouping the y-axis shows each aspect with the matching assets. Multiple groups can be configured for finer granularity.

Link based groupings generate one or multiple hierarchies based on how each asset is connected to assets of a specified target type. These groupings are named "Related to type X" where X is the target asset type.

E.g. you query all applications and want to group them by the virtual servers they run on. To achieve this, choose the "Related to type Virtual Server" and you will get a row per server containing all applications which are connected to this server.

If there are multiple paths from your applications to the virtual servers, but you are only interested in e.g. "runs on", you need to restrict the possible link types which are considered:

Interaction​

To add/remove assets to the gantt chart, they must be included in the query.

The x-axis is displayed twice:

  • The upper scale shows the currently visible time range (depending on your zoom factor).
  • The lower one can be used to choose the visible time range.

Assets can be selected to show the asset in the sidebar.

Styling​

The assets in the y-axis are styled based on the conditional styling. The bars on the x-axis have the color defined in the x-axis configuration.

Export​

The gantt chart can be exported as a PDF, PNG or an SVG file.