Create Metrics Views
Metrics Views are a key part of defining your measures and dimensions.
Metrics 101
- What are Metrics Views? - Define your time series, measures, and dimensions using your OLAP engine aggregate functions
- Underlying Model/Table - When to use
model
ortable
in a metrics view - Time Series - What is a time series column and how to use it in your metrics view
Dimensions
- 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
- Lookup Dimensions - Create dimensions that reference data from other sources
Measures
- 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
Security
- Data Access Policies - Control access to your metrics data with role-based permissions