I have a question - how does the function "having" work in Celonis PQL?I need to select case where Count(Activities)>3.How can i do it is Celonis?Thank you so much!

Hello Anna,

There's no exact function to mimic "having" function as most of aggregation is done automatically by using specific dimentions (if tables are connected to each other). In other cases you need to use usually Pull-up functions or some specific one like DOMAIN / BIND etc..

In order to filter items you need to set filter either on component, sheet, or analysis level.

In you would like to see such items in OLAP table just click on it, go to "Component filer" and paste this PQL code:

FILTER PU_COUNT("<Case_table_name>","<Activity_table>"."_CASE_KEY") > N

Of course you need to replace <> values and N with any number.

Best Regards,

Mateusz Dudek

Hallo Mateusz,

Thank you so much! I tried, but something is wrong:

FILTER PU_COUNT("Testdaten_2019_Celonis_xlsx_gesamt_2019_CASES",

"Testdaten_2019_Celonis_xlsx_gesamt_2019"."ARBEITSPLATZ_OBERBEGRIEF")

> 3

I actually only have one table:

What do I do wrong?

I got it! It works now! Thank you so much, Mateusz!