Skip to main content

CPM46

Charts and tables

Data structure

Data shown in charts and tables is always structured in tables in the background. The difference is, how the dimensions are concatenated in the visualization. To understand which data points are shown to you, keep in mind that configured dimensions and KPIs will be structured in the background in the following way:

Dimension 1

Dimension 2

...

KPI 1

KPI 2

A

01

...

2 days

10k

B

01

...

5 days

100

B

02

...

0 days

3k

...

...

...

...

...

OLAP table

18579967.png

The OLAP table will show all dimensions and KPIs configured in a table:

  1. The dimension and KPI name are shown in the column headers. Click on the header to change the table sorting or search in the dimension columns.

  2. Click on a dimension and create a selection. Selected entries can be copied to the clipboard by right click and the available action.

  3. Confirm, cancel or invert the temporary selection.

  4. Open the component settings. (Only available in the analysis draft.)

  5. Hide and show dimensions and KPIs.

  6. Open the component filter. (Only available in the analysis draft.)

  7. Download the component.

Column, line, area and marker charts

18579974.png

Column, line, area and marker charts all behave the same with the visual representation being the only difference:

  1. Dimensions are concatenated and shown on the dimension axis.

  2. KPIs are by default all shown on the primary value axis.

  3. Click on the chart and drag and drop to create a selection.

  4. Confirm, cancel or invert the temporary selection.

  5. Open the component settings. (Only available in the analysis draft.)

  6. Open the component filter. (Only available in the analysis draft.)

  7. Download the component.

Pie and Donut chart

18579975.png

Pie and donut charts both show the concatenated dimensions as pieces and the size of each piece is defined by the first KPI.

  1. The currently visible dimensions are shown in the legend by default.

  2. Click on a piece to create a selection.

  3. Confirm, cancel or invert the temporary selection.

  4. Open the component settings. (Only available in the analysis draft.)

  5. Open the component filter. (Only available in the analysis draft.)

  6. Download the component.

Bubble plot

18579976.png

The bubble chart shows exactly two KPIs over a selected dimension.

  1. The dimension you configure will be shown on the horizontal axis.

  2. The first KPI will be displayed on the vertical axis.

  3. The bubbles are rendered on the chart. The size is defined by the second KPI. Click the bubble to create a selection on the dimension.

  4. Confirm, cancel or invert the selection.

  5. Open the component settings. (Only available in the analysis draft.)

  6. Open the component filter. (Only available in the analysis draft.)

  7. Download the component.

Histogram chart

18579977.png

The histogram takes a KPI as an input and shows the case distribution on it.

  1. The buckets of the KPI are shown on the horizontal axis.

  2. The number of occurrences is shown on the vertical axis.

  3. The buckets can be selected by click or drag and drop. After confirming the selection, the selected area will be split up again.

  4. Confirm, cancel or invert the selection.

  5. Open the component settings. (Only available in the analysis draft.)

  6. Open the component filter. (Only available in the analysis draft.)

  7. Download the component.

Scatter plot

18579978.png

The scatter plot will plot a point for each case or other item you aggregate on.

  1. The KPI selected for the horizontal axis.

  2. And the KPI selected for the vertical axis define the position of the elements.

  3. Click on single points or drag and drop to create a selection.

  4. You can define a grouping which is used to color the elements. You can click on the groups and create a selection on them.

  5. Confirm or cancel the selection.

  6. Open the component settings. (Only available in the analysis draft.)

  7. Open the component filter. (Only available in the analysis draft.)

  8. Download the component.

Boxplot

22118594.png

A boxplot shows the distribution of a numerical value in a population of cases. In this example, it shows the distribution of throughput time per case. We can also show multiple boxplots in one graph by adding a dimension to visualize the distribution of throughput time per case for each material, for example.

  1. The distribution axis, throughput time per case.

  2. The dimension axis, material.

  3. Confirm or cancel the selection.

  4. Open the component settings. (Only available in the analysis draft.)

  5. Open the component filter. (Only available in the analysis draft.)

  6. Click on single points or drag and drop to create a selection.

  7. Hover over a boxplot to see information about the distribution of cases.