Skip to main content
Question

Hi, if I specified a workday calender data model, and I create cycle time KPI's does that formula run in UCT timezone or will it consider the actual timestamps that I have in my data.

  • June 23, 2023
  • 1 reply
  • 21 views
denise.kruge12
Level 7
Forum|alt.badge.img+19

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?

1 reply

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

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' )

 

 

Community Code of ConductAccessibility statement