This is my formula:
AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("_CEL_MERGED_ACTIVITIES"."TIMESTAMP", HOURS, MONDAY 06:00 - 14:30 TUESDAY 06:00 - 14:30 WEDNESDAY 06:00 - 14:30 THURSDAY 06:00 - 14:30 FRIDAY 06:00 - 14:30)))
Will Celonis look at my actual timestamps or use UTC time?
It will look at the actual time stamp, I am not sure what you use case is but of you need to consider the same in UTC use the following function
CONVERT_TIMEZONE ( table.date_column , from_timezone_id], to_timezone_id )
eg.
CONVERT_TIMEZONE ( "Table"."Timestamp" , 'America/New_York' , 'Europe/Berlin' )
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
