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

image

Any ideas how to do this?

Thanks,
Alex

I guess I need something like this but ACTIVITY_START doesn’t 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 don’t 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