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

Create new dimension based on metric value

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am working with dirty GA data where GA ecommerce was set up to have the same product name be used for different products. ex: the same 'product' dimension for when product X was purchased for $49.00 and product Y was purchased for $600. 

 

I would like to create a calculated field which results in a new dimension where 'new dimension XYZ' = when average price = $49.00

 

I'm at a loss at figuring this out, any thougts?

Create new dimension based on metric value

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Jonathan C,

 

I'm not certain DataStudio would be able to do this for you - it may be better to calculate this using a custom dimension in GA, then use this in DS instead?

 

How many products are you working with and how many price variations are there? I am trying to think of a better way to do this, but struggling also Smiley Happy

 

Let us know if your having any success!

 

Ben