Any ideas how to do this?
Thanks,
Alex
Question
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
Any ideas how to do this?
Thanks,
AlexI 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.