Creating a dimension field from CASE statement
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!