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

Calculated field from Event Category?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want to create a calculated field for 'Cancellations'.

 

In Google Analytics, I track this in an Event with Category 'Cancellation'

 

Is there a way in Data Studio to create a new calculated field for Cancellations?

Calculated field from Event Category?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Jason E

 

The CASE function will do this for you, here's a link to the official documentation for CASE:

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

 

Hope that helps,

Ben

 

 

Calculated field from Event Category?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Ben,

 

With the CASE function I can create a dimension 'Events' that includes the different event categories as metrics. But is there a way I can use a calculated field to make the Cancelled event metric available without having to use an Events dimension?