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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.