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