AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Calculated Fields: How to show negatives red/positives green

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I created a calculated field to do a 52 week comparison - the type is 'Percent', but I don't get anything special for negatives/positives like I would using the comparison option.

 

Is there any way to get the normal comparison functionality with calculated fields (little red and green arrows)? Or any way to make the entire number red/green.

 

I haven't found anything about being able to add styling by using a case statements, which leaved me out of ideas.