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
star_border
Reply

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

https://www.en.advertisercommunity.com/t5/Data-Studio/Can-I-do-a-ratio-between-two-Analytics-Event-A...

however,SUM can not get the unique event count

 

so is there a way to make that work?