PARSE_DATETIME : PARSE_DATETIME(format_string, text).PARSE_DATE : PARSE_DATE(format_string, text).FORMAT_DATETIME : FORMAT_DATETIME(format_string, datetime_expression).EXTRACT : EXTRACT(part FROM date_expression).DATETIME_TRUNC : DATETIME_TRUNC(date_expression, part).DATETIME_SUB : DATETIME_SUB(datetime_expression, INTERVAL integer part).DATETIME_DIFF : DATETIME_DIFF(date_expression, date_expression, part).DATETIME_ADD : DATETIME_ADD(datetime_expression, INTERVAL integer part).DATETIME : DATETIME(year, month, day, hour, minute, second).DATE_FROM_UNIX_DATE : DATE_FROM_UNIX_DATE(integer).These functions are used to manipulate time data.įollowing are examples of Date functions: These functions are used to do mathematical calculations on your data.įollowing are examples of Arithmetic functions: My step-by-step blueprint for using Looker Studio (formerly Google Data Studio) Get the FREE ebook on Looker Studio (75 Pages) For example, Sessions is already summed in your data set, so the formula SUM(Sessions) will produce an error. This includes most metrics found in Google Analytics and Google Ads. Note: Aggregation functions can not be applied to already aggregated data. These functions are used to aggregate data.įollowing are examples of aggregation functions: Types of Looker Studio functionsĪll of the Looker Studio functions are grouped into the following categories: The bottom of the formula editor sometimes provides additional information about how a function is being used and how it should be used.įor example, in the screenshot above, the Looker Studio was expecting arguments ( Expected arguments, but none were provided ). ![]() Note: You can learn more about the values returned by each function from the Google help documentation on each function: ![]() Similarly, the COUNT function returns the total number of items in a field or expression. The ‘AVG’ function returns the average for all values in a field or expression. #5 All functions return a valueįor example, ‘CASE’ function returns dimensions or metrics based on conditional expressions. So if you remember the syntax, you will remember how to use the CASE function. #4 Parameters are listed in the syntaxĪll the parameters which the CASE function expect, are listed in the syntax of the CASE function: Note(2): You can learn more about the parameters used by each function from the Google help documentation on each function: Note(3) : You can click on the ‘ Format Formula ’ button, to make your formula more readable. Note(1): When providing parameters, be sure to enclose the literal text in single or double-quotes. Note: You can learn more about the syntax of each function from the Google help documentation on each function: It defines how parameters (more about them later) must be used.įor example, the following is the syntax for the CASE function :įollowing is the syntax for ‘AVG’ function:įollowing is the syntax for ‘COUNT’ function: Syntax defines how a function must be used. ![]() Note: You can learn more about the purpose of each function from the Google help documentation on each function: #2 Every function in Looker Studio has syntax Similarly, the ‘COUNT’ function is used to count the number of items in a field. The ‘AVG’ function is used to calculate the average value of a numeric field. #1 Every function in Looker Studio has some purposeįor example, the ‘CASE’ function is used to create new fields that use conditional logic to determine the field values. Frequently Asked Questions About Looker Studio Functions, Formulas Tutorial. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |