First, I am not sure if this will make sense because I'm having a hard time describing it to myself... but looking for any guidance or hints on how to approach this...
I have a multi step process where one party is responsible for the first half and another party is responsible for the second half. A simplified example is:
Process Steps:
- New widget
- Widget step 1 done (Party 1)
- Widget step 2 done (Party 2)
I can easily create OLAP tables around specific events... ex.
date widget uploaded, count, most common color
1/1/24, 100, blue
but I'm having a hard time anchoring different events in the process to the same date row when I'm using pull up aggregation to get the counts
General Date, Count uploaded, Count where widget step 1 completed, count where widget step 2 completed
1/3/24, 100, 24, 58
1/2/24, 80, 42, 98
1/1/24, 110, 120, 20
The challenge that I'm seeing is that my PQL statements for each of the columns don't relate to the same date, and I don't know how to dynamically set the date of the left most column.
does this make sense?