Hi Michael ,

Not Sure if I understood your question correctly and answered here.

 

My Undestanding:

You want to show the user and activity & eventtime which has max(activity event time per case)

 

Here is my response.

Better do the same using a trsansformation.

• Create a table with following columns

-- Casekey

-- User

-- activity Name

-- Max(event time of the activity)

 

In the where clause of the select use eventtime=(max eeventtime) e User co-related SubQuery] to form the select or the data and use the same select to create the table..

 

Then in the datapool - link the casekey of the new table to the casekey of the case table.

 

Regards

Ayan

 

---

Hi Michael ,

Not Sure if I understood your question correctly and answered here.

 

My Undestanding:

You want to show the user and activity & eventtime which has max(activity event time per case)

 

Here is my response.

Better do the same using a trsansformation.

• Create a table with following columns

-- Casekey

-- User

-- activity Name

-- Max(event time of the activity)

 

In the where clause of the select use eventtime=(max eeventtime) e User co-related SubQuery] to form the select or the data and use the same select to create the table..

 

Then in the datapool - link the casekey of the new table to the casekey of the case table.

 

Regards

Ayan

 

Hi Ayan,

 

Thank you for your reply.

 

However, I am trying to see if there is a way in PQL to handle this.

I would prefer an option to avoid making another table for the data pool as that would use more resources. This data would not be used as often as other tables.

 

I am able to get the DOMAIN_TABLE function to work, but with limited success on figuring out if there is another way to pull the data outside of PU functions.

 

Any other suggestions?

 

Thank you.

---

Hi Michael,

Have you considered using a sort function? Instead of creating a new table, they would add a sort identifier column.
Additionally, you may concatenate two columns to create a grouping or secondary identifier. These are some possible approaches. We can look at this further if this doesn't fully address the question.


Please take a look at the following help article https://docs.celonis.com/en/activity-table-sorting.html#idm45431739100544


Meaning the above is used when activities occur at the same time for the same case. How do you distinguish?
We use the sort identifier to distinguish.

Please let us know if it makes sense.

Thank you for your patience and understanding,

Bes regards,
Valmira Abdiu

---