This article will cover the
Key features of calculated fields and dataset how to use them to customize your reports—from basic calculations and text manipulation to advanced functions, regular expressions, and custom groups.
- About calculated fields
- Data types
- Features of using calculated fields
- Data Source and Chart Level Calculated Fields: What’s the Difference
- Calculated Field Functions
- Basic Mathematical Operations with Numeric Fields
- Using the lower text function
- Regular expressions in calculated field functions
- Using the case statement
- User groups
About calculated fields
To visualize the data, information downloaded little known ways to rid yourself of list of phone number from an external source, such as Google Analytics, may not be enough. In such cases, it is necessary to:
- add additional indicators;
- make calculations based on existing information;
- create your own variables.
To solve these problems, Looker Studio provides calculated fields.
Calculated fields are formulas that perform mathematical, logical, or other operations on one or more fields from your data source, creating new values based on them.
The data obtained as a result of calculations can be used for visualization , creating dashboards and further analysis.
Calculated fields allow you to:
- perform arithmetic and mathematical operations;
- process text, time and geographic data;
- use functions with branching logic.
Data types
The data types in calculated fields europe email depend on the functions and parameters used. They can be:
- numeric – used to perform mathematical calculations;
- text – for processing text data, for example, filtering, editing, changing case, replacing some text data with others, extraction;
- date and time – used for working with time intervals, planning, duration calculations;
- logical – used for logical expressions, conditions and data filtering;
- geographic – for filtering by geo-parameters (city, country, continent, part of the world);
- currency – for calculations related to monetary values.