Skip to main content
Question

OLAP Table KPI Date Difference - searching for minimum

  • October 27, 2020
  • 3 replies
  • 19 views
A
Level 2
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

3 replies

A
Level 2
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 ) ) )
M
Level 0
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
.
Level 4
  • .14600905
  • Level 4
  • October 28, 2020
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
Community Code of ConductAccessibility statement