Skip to main content

Looker Studio Help

Terms of Service

Submit feedback

Send feedback on...

This help content & information

General Help Center experience

Help Center
Community

Function references

Aggregation

APPROX_COUNT_DISTINCT
AVG
COUNT
COUNT_DISTINCT
MAX
MEDIAN
MIN
PERCENTILE
STDDEV
SUM
VARIANCE

Arithmetic

ABS
ACOS
ASIN
ATAN
CEIL
COS
FLOOR
LOG
LOG10
NARY_MAX
NARY_MIN
POWER
ROUND
SIN
SQRT
TAN

Conditional

CASE (Searched)
CASE (simple)
COALESCE
IF
IFNULL
NULLIF

Date

CURRENT_DATE
CURRENT_DATETIME
DATE
DATE_DIFF
DATE_FROM_UNIX_DATE
DATETIME
DATETIME_ADD
DATETIME_DIFF
DATETIME_SUB
DATETIME_TRUNC
DAY
EXTRACT
FORMAT_DATETIME
HOUR
MINUTE
MONTH
PARSE_DATE
PARSE_DATETIME
QUARTER
SECOND
TODAY
UNIX_DATE
WEEK
WEEKDAY
YEAR
YEARWEEK

Geo

TOCITY
TOCONTINENT
TOCOUNTRY
TOREGION
TOSUBCONTINENT

Miscellaneous

CAST
HYPERLINK
IMAGE
NATIVE_DIMENSION

Text

CONCAT
CONTAINS_TEXT
ENDS_WITH
LEFT_TEXT
LENGTH
LOWER
REGEXP_CONTAINS
REGEXP_EXTRACT
REGEXP_MATCH
REGEXP_REPLACE
REPLACE
RIGHT_TEXT
STARTS_WITH
SUBSTR
TRIM
UPPER

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Language

Enable Dark Mode

Search

Clear search

Close search

Main menu

3024504924055633624

true

Search Help Center

true

true

true

true

true

102097

false