I am trying to filter out activities from cases that take place earlier/later than a user given timestamp.
As of now, I have tried it with the P2P example without any success.
The steps that I took are the following:
In order to make my example simpler, I went to the Case Explorer page and chose only the CASE ID -> 143365
While clicking on this Case I saw 6 activities (Create Purchase Requisition Item, Create Purchase Order Item, Send Purchase Order, Receive Goods, Scan Invoice, Book Invoice). For my example, I wanted only to include the activities found in March. In this case, the only activity found in this month would be Book Invoice.
The way I tried to filter the rest of the activities was with the “Attribute selection”. Then I chose from the “Table And Column” dropdown the “_CEL_P2P_ACTIVITIES” -> “EVENTTIME”-> Datum of Month Marz.
When I go to the Variant Explorer or Process Explorer I still see the rest of the activities that take place previous to Marz.
In the screenshot uploaded below, you can too see the problem.
Since the activities in each case are not in the same order, the filtering should not be activity-based but time-based.
Is this even possible within Celonis?
A bypass would be filtering such activities in the Excel file. I want to avoid it though since I would have to upload different files to the cloud.