Data Studio
4.8K members online now
4.8K members online now
Ask questions about Data Studio
Guide Me

how to calculate a ratio between two specified event aciton

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

hello everyone

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?