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