Functions in Looker Studio are formulas that are used to: Aggregate data. Do mathematical calculations on your data. Manipulate time data. Manipulate geographic location data. Manipulate string data. Functions make your calculated fields more powerful. They are used inside of calculated fields as...
Returns a number of characters from the beginning of a specified string. Sample usage LEFT_TEXT(Campaign, 6) Syntax LEFT_TEXT(X, length) Parameters X - a field or expression of any type.
Simplified CASE expressions You can create simpler, easier to read CASE expressions in calculated fields by declaring the field to test once, then writing the matching values. For example, instead of this: CASE WHEN field=value1 THEN result1 WHEN field=value2 THEN result2 WHEN field=value3 TH...
Returns true if the target value exactly matches the regular expression pattern.Sample usage REGEXP_MATCH(name, '[a-zA-Z].*') Syntax REGEXP_MATCH(X, regular_expression)
Converts a field or expression from one type to another type.Sample usage CAST(Number_field AS TEXT) CAST(Text_field AS NUMBER) CAST(Date_field as DATETIME) Synta
Simplified CASE expressions You can create simpler, easier to read CASE expressions in calculated fields by declaring the field to test once, then writing the matching values. For example, instead of this: CASE WHEN field=value1 THEN result1 WHEN field=value2 THEN result2 WHEN field=value3 TH...