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

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.

Page 1 / 1

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

@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

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN