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

Max 255 Characters in a GDS Formula Field????

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

I've put in a multi stage CASE & REXEXP statement that has gone over 255 characters.

 

 

For example;

 

CASE WHEN REGEXP_MATCH ( field_expression , "" ) Then "Supplier 1" WHEN REGEXP_MATCH ( field_expression , "Something 2") Then "Supplier 2" WHEN REGEXP_MATCH ( field_expression , "Something 3") Then "Supplier 3" WHEN REGEXP_MATCH ( field_expression , "Something 4") Then "Supplier 4" Else "Other" END

 

This works great, however, when you go back in to edit the formula, Google Data Studio crops it down to this;

 

CASE WHEN REGEXP_MATCH ( field_expression , "" ) Then "Supplier 1" WHEN REGEXP_MATCH ( field_expression , "Something 2") Then "Supplier 2" WHEN REGEXP_MATCH ( field_expression , "Something 3") Then "Supplier 3" WHEN REGEXP_MATCH ( field_expression , "Some

 

(255 Characters)

 

This is probably why a lot of users experience formulas that did work but won't let them update the field - it's been cropped!

 

Is there a way to reduce the length of the formula, or can GDS not crop formulas over 255 characters?

Max 255 Characters in a GDS Formula Field????

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭

The size limit for calculated fields has been increased to 2048 characters - latest release. Thank you google!