As dimension I have: PU_FIRST("case_table", "activity_table"."activity_time")

The KPIs I am plotting/I want to plot are:

• throughput time: CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("activity_table"."activity_time", MINUTES))
• AVG of throughput times as a constant function:
  • If I use here AVG(... throughput time ....), then (not so surprisingly) Celonis computes these for the single cases in the "dimension set", i.e. returns the single throughput times --> is not what we want
  • clearly the same happens if I set up a variable with text/replacement "AVG(... throughput time ....)" and call this when defining the KPI in the plot
  • if I set up a variable with a static value being the PQL query AVG(... throughput time ....), then I get a constant function, but it does not filter with selections, i. e. the value of the constant function stays the same independent of what filters one selects

Could you please help me?

Thanks a lot in advance,

Best,

Tamás