Hi

Dear Experts, I want filtering about Case Erruption Ratio (Case/Global Case) like this

ratio = count("table"."ID")/global(count("table"."ID")

​so I'm use component filter

FILTER ( count("table"."ID")/global(count("table"."ID") ) > 0.01

​

but celonis say "COUNT(DISTINCT "Pizza_Event_Pizzeria_Event"."_CASE_KEY") /global (COUNT(DISTINCT "Pizza_Event_Pizzeria_Event"."_CASE_KEY"))"

​

To solve it, I tried to count the number of Caseids and Globals (caseids) with pu_count, pu_count_distinct but it didn't work. Can you tell me how to do it?

​