Skip to main content
Question

Beginner question on how to calculate the throughput time between activities without counting multiple entries

  • December 14, 2023
  • 3 replies
  • 62 views
S
Level 1

Hello everyone,

 

I want to calculate the average delivery time and I chose to do this by calculating the throughput time between activity A and activity B in Studio with this formula:

 

AVG (

  CALC_THROUGHPUT (

    FIRST_OCCURRENCE [ 'A' ]

    TO

    LAST_OCCURRENCE [ 'B ] ,

    REMAP_TIMESTAMPS ( "ACTIVITIES"."EVENTTIME" , DAYS )

  )

)

 

However, Celonis warns me that >> The aggregation function AVG is applied on a column from table "_ACTIVITIES_CASES" which has a 1:N relationship to the common table "ACTIVITIES". << Could anyone tell me what causes this and how I can make sure that there are not multiple entries sabotaging the average?

 

Thank you very much in advance!

3 replies

thomas.guerr
Level 7
Forum|alt.badge.img+1
  • thomas.guerr
  • Level 7
  • December 15, 2023

Hello,

just for clarification: do you have this formula as an alone-standing KPI (in a 'number'-component) or is it in a OLAP-Table with other dimensions or KPIs?

S
Level 1
  • simon.reich
  • Author
  • Level 1
  • December 15, 2023

Hello,

just for clarification: do you have this formula as an alone-standing KPI (in a 'number'-component) or is it in a OLAP-Table with other dimensions or KPIs?

Hi Thomas,

I noticed this might be the problem because this was in an OLAP table with another dimension. When I put it into a single KPI, it was not a problem however it doesn't give me the desired results because I want to see the average throughput time for each service provider (service provider as the dimension).

 

If there is no easy fix for this, is there maybe another way to approach this?

 

Thanks for your time, Thomas

thomas.guerr
Level 7
Forum|alt.badge.img+1
  • thomas.guerr
  • Level 7
  • December 18, 2023

Hi Chase,

you could try by using a Pull-up Function

Pull Up Aggregation (celonis.com)

but be aware of the cardinalities, depending on your data model it could be possible that you have also to use the BIND function, or it might be not so easily possible in the constellation you imagine.

 

Maybe take a look at this also:

Join functionality (celonis.com)

 

It depends on the connection between the table where the information about the service provider is and the Activities-Table.

 

maybe something like

PU_AVG(<case table>,

CALC_THROUGHPUT (

  FIRST_OCCURRENCE [ 'A' ]

  TO

  LAST_OCCURRENCE [ 'B ] ,

  REMAP_TIMESTAMPS ( "ACTIVITIES"."EVENTTIME" , DAYS )

 )

might help.

 

BR THomas

Community Code of ConductAccessibility statement