Question
Activity Table Timestamp in Milliseconds
Hey,
I have a use-case where events can happen super fast.
Hence, I build an activity table with a Millisecond Timestamp.
When I read it in via file upload, it detects the Milliseconds with the format yyyy-mm-dd HH:mm:ss.SSS.
But after loading it does not show the miliseconds in the respective timestamp column, only with seconds.
Do you support Milliseconds for the timestamp column?
Do you have a workaround for proper ordering, when Sorting column would not work?
I would appreciate any help.
Hi, Ive just thought about the same thing. You can create an OLAP table with case id and timestamp column and set the format of the timestamp to %Y-%m-%d %H:%M:%S.%L
You should then see the millis. Kr, Mara
+6@lennart.lehma12 Did you ever find a solution for your issue? Or did you move forward with the solution Mara suggested? If yes, how did you get the milliseconds into Celonis?
@jessica.lugha @mara.aderm11 , Is there a solution to add milliseconds to data from a string conversion or in the data ingestion? I'm having trouble finding a %.... identifier for the milliseconds of a datetime
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.