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
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Formatting question with custom formula containing EventLabel

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

I want to create a new custom field that show the percentage of people actualy signing up.

I have an event that triggers when the user (klant) submits their data.

 

So i thought the calculation would be: amount of users who signed up / total amount of users.

(event label,'(klant)')/users

 

But this does not work. I ge tthe message: invalid formula. What am i doing wrong?

Schermafbeelding 2017-03-02 om 11.45.47.png

 

Best regards,

Thijs

Formatting question with custom formula containing EventLabel

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Thijs K

 

It looks like your using some syntax that isn't supported - you may want to try CASE as an alternative solution which does work with data studio, there's more information at the following link:

https://support.google.com/360suite/datastudio/answer/7020724?hl=en

 

Hope that helps!

Ben

Formatting question with custom formula containing EventLabel

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi @Ben P,

 

Thx for the quick reply!

I am going to have a look at the CASE expression.

 

Regards,

Thijs