Data Studio
3.4K members online now
3.4K members online now
Ask questions about Data Studio
Guide Me

Creating a dimension field from CASE statement

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello all,


I'd like to create a custom dimension using a CASE statement but I can't figure out the correct formula. 


What I'm trying to do is create tiers for my CPC data. Basically what I want to do is create different tiers where tier 1 has CPC = $0.00-$0.09, tier 2 has CPC = $0.10-$0.19, tier 3 has CPC = $0.20-$0.29, etc. 


I want this to be a dimension and not a metric, because I want to use a filter control with these different tiers so I can look and see which tiers are performing the best. 


Does anyone have any suggestions as to what formula I would write to create these tiers? Thank you for your help!