Create Metrics Views

Metrics Views are a key part of defining your measures and dimensions.

What are Metrics Views? - Define your time series, measures, and dimensions using your OLAP engine aggregate functions
Underlying Model/Table - When to use model or table in a metrics view
Time Series - What is a time series column and how to use it in your metrics view
Derived Metrics Views - Create focused subsets by inheriting from a parent metrics view

Dimensions - Categorize and segment your data for analysis and filtering
Navigatable Dimensions - Generate navigable URIs for your dimension values
Unnesting Arrays - Work with array data by expanding nested structures
Time Dimensions - Add multiple time-based dimensions for filtering across different date columns
Lookup Dimensions - Create dimensions that reference data from other sources

Measures - Define calculated metrics and aggregations for your data analysis
Format Measures - Learn how to format and display your metrics effectively
Case Statements and Filters - Use conditional logic and filtering in your measures
Referencing Measures - Reference and combine existing measures in your calculations
Quantiles - Calculate percentiles and quantiles for statistical analysis
Fixed Measures - Create measures with fixed values and constants
Window Functions - Apply window functions for advanced analytical operations

Data Access Policies - Control access to your metrics data with role-based permissions