I am plotting throughput times (ordered by the timestamp of first activity) using a line chart and I also include the average throughput time as constant function. How can I achieve that the value of the constant function also filters with sele

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