Leveraging calculated fields
Calculated fields are custom fields that you can add to data sources and charts. These fields are derived from existing fields in the data source, including other calculated fields. A calculated field can be either a dimension or a metric.
Looker Studio provides several functions grouped under six categories to help create useful calculated fields. These include the following:
- Arithmetic
- Conditional
- Date
- Geo
- Text
- Aggregation
- Miscellaneous
Calculated fields serve many purposes. They enable you to implement business logic, create user-friendly representations of data, and create complex metrics beyond simple aggregations.
Arithmetic functions enable you to perform mathematical operations such as computing logarithms, exponentials, trigonometric values, or nearest integers on numeric data. You can also do simple math using regular operators for addition, subtraction, division, and multiplication. With date functions...
