Skip to main content

Celonis Product Documentation

Analysis - Pivot Table
Pivot Table overview

The Pivot Table is a data processing component to show an 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.

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.

Pivot Table main functionality and settings
18579983.png

  1. Dimensions

    To use the pivot table at least create two, (best three) 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 a 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 the 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 5.

Note

It is 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.

Pivot Table Configure Model
18579985.png

  1. Configure Model

    By clicking on Configure (1) a model 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.

    5. 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 with a minimum of one KPI has to be defined for setting up the pivot table.

    6. Done

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