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_OCCURRENCEC'DRAFT'] TO FIRST_OCCURRENCEC'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 . How do I add it?

Best regards

Alex