Skip to main content
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!

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)


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


Reply