Calculate your data
Calculated fields allow you to create new data from data that already exists in your data source.
You can use calculations to create new dimensions, such as performing cohort analysis, or new measures, such as computing a profit ratio. When you create a calculated field, you are essentially creating a new field (or column) in your data source.
Basic calculations allow you to create and save a new column of data in your data source, derived from values in pre-existing columns in your data source. For example, you can compute people’s ages based off their dates of birth.Create a basic calculation
Level of detail (LOD) expressions
Level of detail (LOD) expressions are similar to basic calculations, but they are calculated at a specific level of detail. For example, repeating country-level education statistics for each university within a country, or providing yearly rainfall totals for side-by-side comparisons with monthly rainfall.Use LOD expressions
Table calculations are computed based on the data in the view and depend on the structure of the view. For example, calculating a moving average, a percentage of a total, or a running total.Use a table calculation