Hi everyone,
Ive created an Approval ratio of cases by using out-of-the-box KPI Ratio of cases flowing through an activity = KPI(Ratio, MATCH_ACTIVITIES(ENDING[Approved] ) = 1).
It works as expected, out of 243343 cases 108698 of them are ending with Approved task which gives rounded up the value of 45% visualised as a Number single KPI component.
However, when the KPI is added to the OLAP table and sliced by example Sales Channel dimension the result in OLAP and Number visuals is different.
In the OLAP table Approval rate is 52% (wrong result) and in Number single KPI component is 31% (correct result). It turns out that in the OLAP table the KPI is switched to count activities instead of cases, hence the result is 52%.
celonis different result1159530 61.2 KB
Is there a catch how to get the same correct % in the OLAP table?
All data is contained within a single table.
Thanks,
Ivan
Page 1 / 1
Hi Ivan,
When breaking down a KPI on a OLAP table ,make sure you are calculating the KPI either all on the case level (you can achieve it with PU functions) or making it all on Activity level.
When using PU functions you might also want to use FILTER_TO_NULL with it in order to make it work in case you have Filters applied
Best
Kevin
Hi Ivan,
You are trying to aggregate KPI on different levels (case level vs activity level).
To get the 45% value (=on activity level), your OLAP table should only contain columns from the activity table and not case such as Sales Order Channel.To aggregate on on Sales order channel, you need to aggregate the count of activities to the Sales Order Channel by using PU Functions.
Example in case you are using SAP SO Channel
KPI formula
SUM (
PU_COUNT(VBAP, ACTIVITYTable.ACTIVITY_EN, MATCH_ACTIVITIES(ENDING[Approved] ) = 1)
)
Best,
Gabriel
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.