Question
Get Count of two temporal related Tables
Hey,
I want to create an OLAP Table, which has the Activity Name as Dimension, Count of other Table within a specific time and the mode of the count as KPIs. Both tables have timestamps and the same ID (see attached image with explainationCelonis_Questions729848 43.2 KB ).
Unfortunately, I have no idea of how to do this with the PQL statements and tried various things but none were successful.
Im using Celonis on-premise 4.6.
I would appreciate any help here.
+2Celonis CPM 4.6 or any version after 4.3 should not be a problem.
Ensure that the activity table and the target table are connected in the Data Model.
If they are not directly connected, you can create a virtual table using DOMAIN_TABLE() celonis.cloud/help/display/CIBC/DOMAIN_TABLE
Best,
Gabriel
In case you have an issue with 1:n relationships you have to work with PU or BIND() functions to make this work. Check out this documentation on PU and BIND
https://confluence.celonis.com/display/PQLdevelopment/BIND
https://confluence.celonis.com/display/PQLdevelopment/PU_FIRST
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.