Skip to main content
Question

Median Throughput with conditions

  • November 15, 2024
  • 0 replies
  • 36 views

Kalex
Level 1
Forum|alt.badge.img

Hi everyone!

 

I am trying to built a Celonis query where I calculate the median time in a process between the Event “DRAFT” and the Event “FINAL”. I would like to additionally get the median value only for one country (e.g. Norway (NO).

I have the following query which seems to work without a country condition:

MEDIAN(
PU_MEDIAN(
DOMAIN_TABLE("ACTIVITY_TABLE."ProcessId"),
CALC_THROUGHPUT(
FIRST_OCCURRENCE['DRAFT'] TO FIRST_OCCURRENCE['FINAL'],
REMAP_TIMESTAMPS(
"ACTIVITY_TABLE"."TIMESTAMP",
hours
)
)
)
)

Now I have problems adding the country condition which would be found in the column ACTIVITY_TABLE.”country”. 

Maybe I have been starring at the query for too long :D. How do I add it?

 

Best regards

Alex

0 replies

Be the first to reply!