Skip to main content
Solved

Throughput calculation

  • January 30, 2025
  • 2 replies
  • 56 views
omar.elmou
Level 5
Forum|alt.badge.img

Dear 

i am puzzled that the calculated throughput time in Celonis is different from the source (excel) data. For example order  O4892 has a throughput time of 12 minutes (according to the raw data in Excel). However the output in Celonis is 1M (1 month?). . Could you please assist by advising on this difference.

Below you can see a screenshot of the data set and output in Celonis.

Many thanks!

 

 

 

 

 

Best answer by kailash.potha12

Hi Omar, Looks like a date format issue while loading data into celonis

    2 replies

    kailash.potha12
    Level 10
    Forum|alt.badge.img+6
    • kailash.potha12
    • Level 10
    • 90 replies
    • Answer
    • January 31, 2025

    Hi Omar, Looks like a date format issue while loading data into celonis

    omar.elmou
    Level 5
    Forum|alt.badge.img
    • omar.elmou
    • Author
    • Level 5
    • 8 replies
    • February 3, 2025

    Thanks ​@kailash.potha12 . Your answer directed me to the solution.I formatted it as a table and saved it as an Excel workkbook instead of csv  The fields were however already in the date format. The newly imported data gave me correct throughput numbers.

     

     


    Community Code of ConductAccessibility statement