Getting different average throughput times between components using same formula

Hi everyone,

I am currently creating a P2P dashboard analyzing different times between activities. The dashboard includes a single number KPI component as well as column charts visualizing the different average throughput times between certain activities. Both the single number component and the column chart are calculated based on the following formula:

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘Create Purchase Requisition’] TO LAST_OCCURRENCE[‘Create Purchase Order’], REMAP_TIMESTAMPS(“Data_csv”.“EVENT TIME:TIMESTAMP”, DAYS)))

The only difference is that the column chart uses different company areas as dimensions (“Data_csv"."CASE SPEND AREA TEXT”) while the number component only uses the formula above.

If I then select/ filter for one specific area in the column chart component, the number component updates but always shows a different number than the column chart.
I don’t understand why two components display different times if they are based on the same formula. I guess it must have something to do with the way the average is calculated.

image

I am still a Celonis rookie so please excuse my question in case I oversaw something obvious.

Best regards
Jeff

Hi Jeff,

it’s difficult to comment on your question without knowing your data model.
but maybe you can check that if you really can calculate throughput per dimension/column of activity table (assuming Data_csv is your activity table)? I doubt that because throughput should be calculated on case level at least.

another thing you may need to pay attention to is that filtering in Celonis has bi-directional impact on tables at the two side of each of “foreign key”. So, depending on where you set filter, it may have different impact on your aggregation formula.

Cheers,
Denny