Skip to main content

CPM46

Pivot table

The pivot table is a data processing component that shows a KPI based on a minimum of two dimensions to apply sorting, averaging or summing of data. The component can be used to show information on a KPI in multiple levels and identify bottlenecks at first glance with common Celonis table settings.

General overview
18579981.png

  • KPI

    The selected KPI is displayed based on the selected dimensions. Multiple KPIs can be chosen and prepared by the analyst and the viewer can change between the KPIs under “Configure”.

    18579982.png

  • Dimensions

    The dimensions are the basis for the rows and columns of the pivot table. The pivoting element is selected and can be changed in “Configure”.

  • Summaries row (bottom) and column (right).

    The selected KPI can be added to the table and show the aggregated data.

  • Colour mapping can be applied in the settings to easier navigate through the data.

Main functionality and settings
18579983.png

  1. Dimensions

    To use the pivot table at least create 2, (best 3) dimensions. The dimensions are defining the Pivot Dimension and the rows shown in the table.

  2. KPIs

    The pivot table can only show one single KPI. Note that flexible switching between different KPIs can either be done under Configure (4) or by the use of variables. The selected KPI can also be added to as summary for each row and column.

  3. Pivot dimension and selected KPI

    The pivoting element will define which dimension is used for the columns (4), the same applies for the selected KPI. For initial set up of the pivot table the first dimension and KPI in the list (1)(2) are selected automatically. The maximum number of pivoting elements that can be shown is 80.

  4. Hierarchy

    The hierarchy shown in the rows of the pivot table is defined by the order of the dimensions in the settings and can be adjusted by the user under Configure (4).

  5. Summary of selected elements

    The summary above the pivot table shows which pivoting element (“Pivot”), which KPI (“KPI”) and which dimensions (“Rows”) are selected. The maximum number of rows is five.

Note

It's not possible to directly filter on a KPI. It is possible to select any pivoting element and any row. After one selection, the pivot table is reloaded.

Configure modal
18579985.png

  1. Configure modal

    By clicking on Configure (1) a modal is accessible both for analysts and viewers. The user is able, once the pivot table is set up, to flexibly adjust the pivot table configuration. Adjustable are the pivot element, the row order and the selected KPI. Common Celonis features like sorting and visible/invisible functionality are also included.

  2. Dimensions

    The dimensions are listed with one of them is the pivoting element (3) which can be changed. The order of the other dimensions defines the hierarchy of the rows (4). The hierarchy can be changed with drag and drop and is defined with the first dimension in the list (which is not the pivoting element) is the 1st level row. The rows can be sorted and made invisible or visible. The maximum of the rows is limited to 5 and the pivoting element to 80.

  3. KPIs

    The pivot table can only show one single KPI. Note that flexible switching between different KPIs can either be done in the dropdown menu; a minimum of one KPI has to be defined when setting up the pivot table.

  4. Done

    By clicking on Done (6), the changes are applied and the pivot table is reloaded.