Date: Fri, 29 Mar 2024 09:17:49 +0100 (CET) Message-ID: <636349292.2709.1711700269334@donny.celonis.de> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2708_238859540.1711700269334" ------=_Part_2708_238859540.1711700269334 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Components require the configuration of Dimensions= and KPIs.
Dimensions basically represent the columns of the table you selected as = data source for this document. In contrast to KPIs, there are no restrictio= ns as to which data types can serve as dimensions therefore all columns ava= ilable in the table can be selected. Your choice of a dimension will define= the possible level of KPIs for your data. If, for example, you add a dimen= sion containing dates and want to round all dates to month, there will be a= maximum of twelve possible KPIs for one year. However, if you round the di= mension to years, there will =E2=80=93 for one year =E2=80=93 only be one e= ntry with one KPI in your analysis component.
There is no limit of dimensions, however, you should keep in mind that t= oo much dimensions might increase the complexity of the component for a vie= wer of your analysis.
KPIs are functions that consolidate a set of values belonging to a singl=
e occurrence inside a dimension into one single value. Consolidation can be=
done by accumulating the values, by calculating the average, minimum or maximum or simply by
To give a short example let's assume your data contains a table listing = all invoices you received from vendors and their respective order values. N= ow if you choose "vendor" as dimension and the sum of "order value" as KPI,= for each vendor all entries in your data will be accumulated regarding the= ir order values. Your result set will contain one entry for each vendor and= his respective sum of order values. If you choose "avg" as aggregation fun= ction, the average of the order values will be calculated for each vendor. = If you choose "min" or "max", the minimum or maximum order value will be se= lected and presented in the result set.
Apart from the function "count" all KPI functions need to be based on anoth=
er column than the dimension column. Since these functions can only be perf=
ormed on numerical data, only columns containing numerical data types will =
be available for selection. Basically, the table selected as data source wi=
ll be scanned for numerical data types and all columns meeting the criteria=
will be provided as bases for KPIs.
The function "count" simply counts the number of occurrences for each value=
in the dimensions column (so for our vendor example, the result set would =
contain an entry for each vendor and the number of invoices you received fr=
om him). If you use KPIs with two or more dimensions KPIs will be calculated for each unique combination of all dimens=
ion values occurring in the data source.
Depending on the Chart Type, the number of possible dimensions and = KPIs will vary (please see the following table). Only Charts And Tables are listed.
Chart Type |
Dimensions |
KPIs |
---|---|---|
OLAP Table |
=E2=88=9E |
=E2=88=9E |
Column Chart |
1 |
=E2=88=9E |
Pie Chart |
1 |
1 |
Donut Chart |
1 |
1 |
Line Chart |
1 |
=E2=88=9E |
Area Chart |
1 |
=E2=88=9E |
Scatter Chart |
1 or 2 |
1 or 0 |
Bubble Chart |
1 |
2 |
Proceed to the Form= ula Editor and learn how to use dimensions and KPIs in your analysis.= strong>