Analyze your data in graphic visualizations

In addition to the data table where you can edit and filter your data, you can display your data in many different graphic visualizations including Gantt charts (timelines), bar charts, line charts, spine charts, radar charts, pie charts, area charts, spine area charts, waterfall charts, doughnut charts, and Kanban reports.

The data displayed in the data table - whether it is the total dataset or a subset of data - is the dataset used for all types of visualizations om tje data workbench. This enables you to create an ad-hoc data source that is relevant for a visualization like a bar chart, Gantt chart, Kanban board, etc. Therefore, it is important to think about the filters that have been set or that you need to set before you leave the data table and go to view the data in the line chart. You should set filters to reduce the data so that your visualization is meaningful. The following visualizations are available for a data workbench:

Click a chart in the infographic to find out more about what to do next.

  

Bar 

Click Visualize Data > Business Charts > Bar Chart. Click Business Chart Settings to set up the bar chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Series Definition: Select one or more attributes to specify a data series to further distinguish the results based on a selected attribute. The series is represented by bars of the same color in a bar chart.
  • Graphic Title: Enter a title to display for the visualization.
  • Bar Series Placement: The default value is Normal.
    • Normal: Place simple bars next to one another to render a bundle of bars for each X-value. Each data series point is represented as a separate bar.
    • Stacked: Display a single stacked bar for each X-value where the data series points are represented as stack elements of the bar.
    • Overlapped: Display a single bar for each X-value where the two data series points are represented as an overlapped and an overlapping bar positioned in front of one another.
  • Bar Orientation: Set a checkmark to orient the bars vertically. Clear the checkmark to orient the bars horizontally.

Line 

Click Visualize Data > Business Charts > Line Chart. Click Business Chart Settings to set up the line chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Series Definition: Select one or more attributes to specify a data series to further distinguish the results based on a selected attribute. The series is represented by different lines in the line chart.
  • Graphic Title: Enter a title to display for the visualization.

Spline 

Click Visualize Data > Business Charts > Spline Chart. Click Business Chart Settings to set up the spline chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Series Definition: Select one or more attributes to specify a data series to further distinguish the results based on a selected attribute. The series is represented by different lines in the spline chart.
  • Graphic Title: Enter a title to display for the visualization.

Pie 

Click Visualize Data > Business Charts > Pie Chart. Click Business Chart Settings to set up the pie chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis. X-values are shown as sections in the pie chart.
    • For pie charts or doughnut charts: X-values are shown as sections.
    • For waterfall charts: X-values are used as labels on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Graphic Title: Enter a title to display for the visualization.

Radar 

Click Visualize Data > Business Charts > Radar Chart. Click Business Chart Settings to set up the radar chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis. X-values correspond to the radiuses of the radar chart.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Series Definition: Select one or more attributes to specify a data series to further distinguish the results based on a selected attribute. The series is represented by colors in the radius chart.
  • Graphic Title: Enter a title to display for the visualization.

Area 

Click Visualize Data > Business Charts > Area Chart. Click Business Chart Settings to set up the area chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Series Definition: Select one or more attributes to specify a data series to further distinguish the results based on a selected attribute. If more than one attribute is specified for the Series Attributes field, set a checkmark for the Stacked Area Chart attribute if multiple series shall be stacked on each other. Clear the checkbox if the series shall be displayed independently from one another.
  • Graphic Title: Enter a title to display for the visualization.

SplineArea 

Click Visualize Data > Business Charts > Spline Area Chart. Click Business Chart Settings to set up the spline area chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis. X-values are used as labels on the X-axis.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Graphic Title: Enter a title to display for the visualization.

Doughnut 

Click Visualize Data > Business Charts > Doughnut Chart. Click Business Chart Settings to set up the doughnut chart.

Click Visualize Data > Data Table to return to the data table to change the attributes available in the X-Value Definition or Series Definition fields, or to modify the filters of the data workbench to add or remove objects in the chart. For more information, see Decide which data you want to see.

  • X-Value Definition: Select one or more attributes to show as the value on the X-axis. X-values are shown as sections in the doughnut chart.
  • Y-Value Definition: Select either <RecordCount> to show the total number of records or a different number value to display on the Y-axis.
  • Graphic Title: Enter a title to display for the visualization.

Gantt 

A Gantt chart displays objects on a timeline. A Gantt chart is only meaningful for object classes that have start and end dates or other custom data attributes. Click Visualize Data > Gantt Chart. Click Gantt Settings to set up the visualization.

Click Visualize Data > Data Table to return to the data table to modify the filters of the data workbench to add or remove objects in the Gantt chart. For more information, see Decide which data you want to see.

  • Define the time schedule settings:
    • Calendar Unit: Specify whether to display the timeline in years, quarters, months, or weeks.
    • Start with Current Year: Select if the current year shall be the start year of the Gantt chart. To focus on a different timeframe, define a specific start year in the Calendar Start Year and end year in the Calendar End Year fields.
  • Define the display of object information:
    • Column Caption: Specify an caption for the column displaying the object information.
    • Object Attributes to Display: Select the attributes to display for the objects. You can either have each attribute displayed in its own column or select the Object Attributes in One Column checkbox to display them in only the first column.
    • Attribute for Start Date and Attribute for End Date: Define the date attribute to use to determine the start and end dates of the bars in the Gantt chart.

Kanban 

Click Visualize Data > Kanban Report. The following is possible in Kanban reports:

Click Visualize Data > Data Table to return to the data table to change the attributes available for the columns, or to modify the filters of the data workbench to add or remove objects in the Kanban report. For more information, see Decide which data you want to see.

  • Define the content of the Kanban. Click Kanban Settings to design the Kanban board.
    • Visualize lanes in the Kanban: Define the Column Definition field. A column is displayed for each value of the selected attribute. For example, if you select Status, then a column is added for each status value. If you select a role, a column will be created for each user assigned the role.
    • Visualize a matrix in the Kanban: Define the Column Definition and Row Definition fields.
      • The same value should not be defined in both fields.
      • To remove the value for the row or column, select the empty row in the drop-down of the relevant field.
    • Show information on the items: Select the attributes to show in the Item Definition field. It is recommended to only show a few attributes on the matrix items.
  • Edit values in the Kanban: You can change the value for the attribute (or indicator, role, etc.) represented by the columns. For example, if Status is selected for the column definition, you can move an object from one column to another to change its status value.
    • If one or more objects in the Kanban board does not have a value defined for the selected attribute (or indicator, role, etc.), the first column will display those objects under an empty header. These objects can be assigned the missing value by moving them to the relevant column. For example, if the role Architect is selected for the column definition, all objects that do not have the role Architect defined are displayed in the first column.
    • Move an object via drag-and-drop to another column to easily redefine the object. Objects can only be moved if the attributes specified for the corresponding column and row definitions are configured to have read-write access permissions.
    • Press CTRL+C to copy a selected object to multiple columns. This is only possible if the attribute specified for the column definition supports multiple references. For example, an application can be assigned to multiple application groups or an application may be specified to have multiple users responsible for it via a role.