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

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 E 'A' ]

  TO

  LAST_OCCURRENCE C 'B ] ,

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

 )

might help.

BR THomas