Question

Thelanguageof my account isn't English. I copied an English metric or attribute formula from an Explore recipe but Explore doesn't recognize the formula and returns a syntax error.

Answer

The formula editor in Explore is language-specific and does not recognize English formulas when the user profile is set to a non-English language. As a workaround, generate a language-specific version of the formula by following the steps below.

1. Temporarily switch youruser profile languageto English.
2. Create the custom metric or attribute formula. The system will no longer return a syntax error.
3. 切换回原来的语言在你的用户profile.

The formula is now automatically translated to your original language.

Find below a visual demo for English to Spanish:

For more information, see the article:Creating standard calculated metrics and attributes.