Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How to create an international users custom Metric [GA Data]

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Code would be something like

 

Sum( case when [country] != 'MyLand' then users else 0 end)

 

Getting errors when attempting this - any ideas?

How to create an international users custom Metric [GA Data]

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Can a custom metrics be even created in GA directly to accomplish this?

Re: How to create an international users custom Metric [GA Data]

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Latest GDS update included:

 

Metrics in CASE statements

You can now use metrics in CASE statements. Learn more about CASE.

 

Not in the above example you cant. I get the error: 'An expression can have either metrics, or dimensions, but not both.'