AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.4K members online now
4.4K 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?