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