how to calculate a ratio between two specified event aciton
suppose i have an event aciton called 'not_pass',and another aciton called 'passed'
i was trying to calclate a "passed rate",which based the unique event count of these 2 event actions;
and the FAKE formula would be like
passedVar= (CASE WHEN event action ='passed' then unique events END);
not_passedVar= (CASE WHEN event action ='not_pass' then unique events END);
passedRate = passedvar/(passedVar+not_passedVar)
there is another guy ask a similar question
however,SUM can not get the unique event count
so is there a way to make that work?