Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre…
Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre computing values in the source query. Level of detail (LOD) expressions let you specify the granularity at which to calculate aggregations, independently of the fields (also called dimensions) in your query. This lets you compute metrics like percent of total, where the denominator aggregates at a coarser grain than the query.
Reduces operational overhead and unlocks new capabilities for data teams on Databricks.
Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre computing values in the source query. Level of detail (LOD)…
Read the full documentation ↗