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

Can I extract string from dimension ?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Can text data be extracted from a dimension field and be used as a text ?

 

Use case: Display the customer name on a report based on a list of customer names

Marked as Best Answer.
Solution
Accepted by topic author Anton B
December 2016

Can I extract string from dimension ?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Anton B,

 

You could extract text from a dimension using REGEXP_EXTRACT, but you can't currently display this on your report simply as text. You may be able to use a data table and style it to your requirements.

 

Hope this helps!

Ben

Can I extract string from dimension ?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Ben, that worked - good work around!