OLAP Table KPI Date Difference - searching for minimum

Hi Community,
I would like to calculate the date difference from the minimum activity start date of the corresponding case to the start date of each activity.
My OLAP table looks like this:
Dimensions: CASE, SORTING, ACTIVITY, START TIME, END TIME

Any ideas how to do this?
Thanks,
Alex

Page 1 / 1

I guess I need something like this but ACTIVITY_START doesnt work:
CALC_THROUGHPUT (
CASE_START
TO
ACTIVITY_START ,
REMAP_TIMESTAMPS (
Activities.START DATE ,
DAYS ,
WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY )
)
)

Hi AlexKw94,
May you can use " throughput time search" instead of Olap table.
So, you can easily find the throughput time between the last-first date.
Even,when you use it, you dont need to calculate the date difference.
Best Regards,
Metehan

Hello @AlexKw94,
You can use the SOURCE, TARGET function along with the DATEDIFF function.
Similar kind of example is in the PQL documentation. Looking into the example will solve your purpose.
Following is the path
Go to PQL>>PQL Function Library>>Process>>Process Reference>>SOURCE-TARGET
DATE781534 49.7 KB

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN