University > Data Studio course > Data Studio Formulas & Calculated Fields

Data Studio Formulas & Calculated Fields

Master Data Studio formulas and calculated fields with syntax and examples for text, dates, math, logic and conditional functions.

Advanced

Start with the foundations.

Take the lessons in order for a complete introduction, or open the topic that answers your current reporting question.

ABS function: How to use & example

Learn how to use the ABS function in Looker Studio to return absolute values. Explore its syntax, practical use cases, and examples for data analysis.

ACOS function: How to use & example

Learn how to use the ACOS function in Looker Studio to calculate the inverse cosine of a value. Discover syntax, use cases, and practical examples.

ASIN function: How to use & example

Learn how to use the ASIN function in Looker Studio to compute inverse sine values. Explore its syntax, examples, and key use cases for data calculations.

ATAN function: How to use & example

Discover how to use the ATAN function in Looker Studio to determine inverse tangent values. Learn its syntax and explore step-by-step examples.

AVG function: How to use & example

Learn how to use the AVG function in Looker Studio to compute average values. Understand its syntax, applications, and examples for data analysis.

CASE WHEN function: How to use & example

Learn how to use the CASE WHEN function in Looker Studio to create conditional logic. Explore its syntax and practical examples for better data analysis.

CAST function: How to use & example

Discover how to use the CAST function in Looker Studio to convert data types. Learn its syntax and see examples for better data transformation.

CEIL function: How to use & example

Learn how to use the CEIL function in Looker Studio to round numbers up. Explore its syntax, use cases, and examples for accurate data calculations.

COALESCE function: How to use & example

Discover how to use the COALESCE function in Looker Studio to manage null values. Learn its syntax, key use cases, and examples for cleaner data analysis.

CONCAT function: How to use & example

Learn how to use the CONCAT function in Looker Studio to merge text values. Explore examples and best practices for effective text handling.

CONTAINS_TEXT function: How to use & example

Discover how to use the CONTAINS_TEXT function in Looker Studio to check if a text contains specific words. Learn its syntax with useful examples.

CURRENT_DATE function: How to use & example

Discover how to use the CURRENT_DATE function in Looker Studio to retrieve today’s date. Learn its syntax and examples for time-based analysis.

COUNT_DISTINCT function: How to use & example

Discover how to use the COUNT_DISTINCT function in Looker Studio to count unique values. Learn its syntax and examples for better reporting.

DATE function: How to use & example

Learn how to use the DATE function in Looker Studio to create, modify, and format dates. Discover its syntax, key use cases, and practical examples.

DATETIME_ADD function: How to use & example

Discover how to use the DATETIME_ADD function in Looker Studio to add time intervals to dates. Learn its syntax, key use cases, and practical examples.

DATE_DIFF function: How to use & example

Learn how to use the DATE_DIFF function in Data Studio (formerly Looker Studio) to calculate differences between dates. Explore syntax, examples, and key use cases.

CURRENT_DATETIME function: How to use & example

Learn how to use the CURRENT_DATETIME function in Looker Studio: syntax, examples, limitations, and pro tips. Master functions in Looker Studio with Catchr.

DATETIME function: How to use & example

Discover how to use the DATETIME function in Data Studio to create and format date-time values. Learn its syntax, key use cases, and practical examples.

DATETIME_DIFF function: How to use & example

Learn how to use the DATETIME_DIFF function in Looker Studio to calculate differences between date and time values. See syntax and examples.

EXTRACT function: How to use & example

Learn how to use the EXTRACT function in Looker Studio to retrieve specific date components like year, month, or day. See syntax and examples.

DATE_FROM_UNIX_DATE function: How to use & example

Explore how Looker Studio's DATE_FROM_UNIX_DATE function simplifies and enhances timestamp data analysis, making data more readable and usable.

COS function: How to use & example

Learn how to use the COS function in Looker Studio to compute cosine values. Discover its syntax and examples for mathematical data analysis.

COUNT function: How to use & example

Learn how to use the COUNT function in Looker Studio to count the number of entries in a dataset. Discover syntax, use cases, and practical examples.

DATETIME_SUB function: How to use & example

Discover how to use the DATETIME_SUB function in Looker Studio to subtract time intervals from dates. Learn its syntax and practical examples.

DATETIME_TRUNC function: How to use & example

Explore the versatility of DATETIME_TRUNC function in Looker Studio to simplify data interpretation and visualization, through managing data granularity.

DAY function: How to use & example

Explore the DAY function in Looker Studio to extract key insights by evaluating the day of the month from any given date. Learn its usage and limitations.

ENDS_WITH  function: How to use & example

Explore the functionality of the 'ENDS_WITH' function in Looker Studio, including its syntax, examples, limitations, and tips for effective use in data analysis

HOUR function: How to use & example

Discover how to use the HOUR function in Looker Studio to extract the hour from a date-time value. Learn its syntax, use cases, and examples.

FORMAT_DATETIME function: How to use & example

Learn how to use the FORMAT_DATETIME function in Data Studio to format date-time values. Discover its syntax, key use cases, and practical examples.

FLOOR function: How to use & example

Discover how to use the FLOOR function in Looker Studio to round numbers down to the nearest whole value. Learn syntax and practical examples.

HYPERLINK function: How to use & example

Explore the HYPERLINK function in Looker Studio—enhance your data representation, create interactive tables and charts, and effectively manage your data.

IF function: How to use & example

Discover how to use the IF function in Data Studio (formerly Looker Studio) to apply conditional logic in reports. Learn syntax, use cases, and practical examples.

IFNULL function: How to use & example

Explore the versatile function IFNULL in Looker Studio and learn how it can manage null outcomes to improve the accuracy of your data analysis.

LEFT_TEXT  function: How to use & example

Dive into the comprehensive guide to understand the LEFT_TEXT function in Looker Studio. Learn about its syntax, usage, and tips for better data analysis.

LENGTH function: How to use & example

Discover how to use the LENGTH function in Looker Studio to count the number of characters in a text field. Learn syntax, use cases, and examples.

MAX function: How to use & example

Discover how to use the MAX function in Looker Studio to identify the highest value in a dataset. Learn its syntax and real-world applications.

MEDIAN function: How to use & example

Learn how to use the MEDIAN function in Looker Studio to determine the middle value of a dataset. Explore syntax, examples, and key use cases.

IMAGE function: How to use & example

Learn how to enhance your data visualization by using the IMAGE function in Looker Studio. The article explains syntax, benefits, and limitations.

LOG function: How to use & example

Explore the LOG function of Looker Studio with this guide, covering its syntax, uses, limitations, and tips for more effective and precise data analysis.

NARY_MIN function: How to use & example

Learn how to use the NARY_MIN function in Looker Studio to determine the lowest value across multiple fields. Explore syntax, use cases, and examples.

LOG10 function: How to use & example

Discover how to use the LOG10 function in Looker Studio to process and interpret your data. Expand your data analysis skills and obtain meaningful insights.

YEAR function: How to use & example

Learn how to use the YEAR function in Looker Studio to extract the year from a date field. Discover syntax, use cases, and examples for time analysis.

YEARWEEK function: How to use & example

Discover the YEARWEEK function in Looker Studio; learn its syntax, how it works, see useful examples, understand its limitations, and get pro tips.

WEEKDAY function: How to use & example

Explore the power of WEEKDAY function in Looker Studio. Learn about its syntax, working, and practical application for analyzing data based on weekdays.

REGEXP_EXTRACT function: How to use & example

Explore the powerful REGEXP_EXTRACT function in Looker Studio to enhance your data extraction and manipulation capabilities, driving focused insights.

REGEXP_MATCH function: How to use & example

Discover the power of REGEXP_MATCH in Looker Studio. Learn how to efficiently sift through text data, match, filter, categorize information and more.

PARSE_DATE function: How to use & example

Explore the usage, syntax, working, and limitations of PARSE_DATE() function in Data Studio (formerly Looker Studio) that allows date conversions and extraction in various formats.

PERCENTILE function: How to use & example

Learn how to use the PERCENTILE function in Looker Studio to determine percentile rankings in a dataset. Explore syntax, examples, and use cases.

LOWER function: How to use & example

Dive into Looker Studio's LOWER function that refines data by converting uppercase characters to lowercase, allowing data consistency and efficient analysis.

MIN function: How to use & example

Discover how to use the MIN function in Looker Studio to find the lowest value in a dataset. Learn its syntax, key use cases, and practical examples.

MINUTE function: How to use & example

Learn how to use the MINUTE function in Looker Studio to extract minute values from date-time fields. Explore syntax and practical applications.

NULLIF function: How to use & example

Explore the NULLIF function in Looker Studio and how it can enhance your data understanding by managing specific data points and handling large datasets.

NARY_MAX function: How to use & example

Understand how to efficiently determine the highest value among multiple inputs using the NARY_MAX function within Looker Studio. Maximize your data analysis.

PARSE_DATETIME function: How to use & example

Discover how to use the PARSE_DATETIME function in Looker Studio for efficient data conversion, its syntax, examples, limitations, and helpful tips.

POWER function: How to use & example

Discover how to use the POWER function in Looker Studio to compute exponentiation. Learn its syntax, use cases, and real-world applications.

QUARTER function: How to use & example

Explore the utilization of the QUARTER function in Looker Studio for segmenting dates into clear, actionable periods for comprehensive data analysis.

REGEXP_CONTAINS function: How to use & example

Explore the power of text string search using REGEXP_CONTAINS function in Looker Studio, master its syntax, and learn how to extract specific data patterns.

REGEXP_REPLACE function: How to use & example

Learn how to use the REGEXP_REPLACE function in Looker Studio to replace specific text patterns. Discover its syntax, key use cases, and practical examples.

REPLACE function: How to use & example

Explore the REPLACE function in Looker Studio, a pivotal tool in data manipulation and communication. Learn its syntax, applications, limitations, and tips.

RIGHT_TEXT function: How to use & example

Learn how to use the RIGHT_TEXT function in Looker Studio to extract characters from the end of a text string. Explore syntax, use cases, and examples.

ROUND function: How to use & example

Get insights on how to effectively use the ROUND function in Looker Studio for data cleaning and uniformity. Learn the syntax and practical usage with examples.

SECOND function: How to use & example

Explore the potential of the SECOND function in Looker Studio. Learn how it simplifies time analysis by isolating the seconds component of your data.

SIN function: How to use & example

Dive into the details of Looker Studio's SIN function – a tool that calculates the sine from an angle input. Discover its uses, limitations and tips.

UPPER function: How to use & example

Understand the use of the UPPER function in Looker Studio, that enables you to convert text fields or expressions into uppercase effortlessly.

UNIX_DATE function: How to use & example

Learn how to use the UNIX_DATE function in Looker Studio to convert date values into numerical form for better time-based analysis and reporting.

WEEK function: How to use & example

Discover how to use the WEEK function in Looker Studio for in-depth weekly data analysis and presentation. Learn syntax, application, limitations, and tips.

TRIM function: How to use & example

Explore the unique uses of the TRIM function in Looker Studio for data cleaning and string manipulation and discover its advantages and limitations.

TOSUBCONTINENT function: How to use & example

Dive into Looker Studio's ToSubcontinent function, a tool that adds geographical granularity to data sets. Learn how it works, its benefits, and limitations.

TOREGION function: How to use & example

Discover how to use the powerful TOREGION function in Looker Studio for geographical data conversion. This function changes ISO codes into full region names.

TODAY function: How to use & example

Learn how to use the TODAY function in Looker Studio to retrieve the current date dynamically. Explore syntax, use cases, and practical applications.

TOCOUNTRY function: How to use & example

Learn how to use the TOCOUNTRY function in Looker Studio to extract country names from geographical data. Explore syntax and practical cases.

TOCONTINENT function: How to use & example

Discover how to use the TOCONTINENT function in Looker Studio to convert country names into their respective continents. Learn syntax and examples.

TAN function: How to use & example

Learn how to use the TAN function in Looker Studio to compute the tangent of an angle. Explore syntax, use cases, and mathematical applications.

SUM function: How to use & example

Discover how to use the SUM function in Looker Studio to add numerical values. Learn its syntax, best practices, and real-world applications.

SUBSTR function: How to use & example

Explore the versatile SUBSTR function in Looker Studio for efficient data extraction, breaking data into selective sequences for focused analysis.

STARTS_WITH  function: How to use & example

Learn how to use the STARTS_WITH function in Looker Studio to check if text begins with a specific phrase. Explore syntax and practical examples.

SQRT function: How to use & example

Discover how to use the SQRT function in Looker Studio to calculate square roots. Learn its syntax, use cases, and practical examples for data analysis.

TODATE function: How to use & example

Explore the TODATE function in Looker Studio, a versatile tool for date and time handling in your data sets. Maximize your data interpretation efficiency!

STDDEV function: How to use & example

Discover how to use the STDDEV function in Looker Studio to measure standard deviation. Learn its syntax, use cases, and statistical applications.

VARIANCE function: How to use & example

Discover how to use the VARIANCE function in Looker Studio to analyze data variability. Learn its syntax, use cases, and statistical applications.
No items found.

Your next report should not start with five exports.

Connect your marketing platforms and build a data workflow your entire agency can use.

Start your free-trialBook a demo
14 days free-trial
No credit-card required
100+ sources