Skip to main content
Question

Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)?Thanks for the help!

  • June 21, 2023
  • 2 replies
  • 1 view

Forum|alt.badge.img+4
Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)? Thanks for the help!

2 replies

  • June 21, 2023

Hi Siemen,

 

yes it is possible, try this Formula:

  • DATEDIFF ( time_unit, table.date_column1, table.date_column2 )
  • DAYS_BETWEEN ( table.column1, table.column2 )
  • WORKDAYS_BETWEEN ( start_date, end_date, calendar_specification [, calendar_id_column])

here the link for more functions: DateTime Difference (celonis.com)


kailash.potha12
Level 10
Forum|alt.badge.img+6

DATEDIFF ( time_unit, PU_FIRST(Case_KEY, EventTime, Filter condition to pick Activity), Date_Column2)