Meta tags:
description=Create metrics views using source data and models with time, dimensions, and measures;

Headings (most frequently used words):

metrics, create, views, 101, dimensions, measures, performance, security,

Text of the page (most frequently used words):
#metrics (19), your (13), measures (12), and (12), #dimensions (11), views (10), rill (8), data (8), time (7), for (6), create (5), what (4), are (4), series (4), project (4), performance (3), access (3), with (3), functions (3), analysis (3), reference (3), use (3), filtering (3), view (3), table (3), model (3), developer (3), policy (2), security (2), 101 (2), control (2), based (2), rollups (2), window (2), fixed (2), values (2), quantiles (2), how (2), format (2), define (2), from (2), other (2), derived (2), underlying (2), build (2), api (2), deploy (2), dashboards (2), files (2), configuration (2), quickstart (2), 2026, inc, contributing, community, terms, service, privacy, next, optimization, previous, role, permissions, policies, accelerate, queries, routing, pre, aggregated, rollup, tables, apply, advanced, analytical, operations, constants, calculate, percentiles, statistical, combine, existing, calculations, referencing, conditional, logic, case, statements, filters, learn, display, effectively, calculated, aggregations, that, sources, lookup, add, multiple, across, different, date, columns, work, array, expanding, nested, structures, unnesting, arrays, generate, navigable, uris, dimension, navigatable, categorize, segment, focused, subsets, inheriting, parent, column, when, using, olap, engine, aggregate, key, part, defining, this, page, home, release, notes, tutorials, postmessage, iframe, embed, managing, errors, configure, deployment, credentials, cloud, debugging, external, ide, integration, organize, code, alerts, custom, apis, sql, annotations, models, connectors, first, why, agentic, install, get, started, search, github, blog, contact, rest, cli, url, parameters, iso, 8601, syntax, guide, developers, skip, main, content,

Text of the page (random words):
create metrics views rill skip to main content developers guide reference project files time syntax rill iso 8601 url parameters cli rest api contact us blog github search get started install rill developer agentic quickstart quickstart why rill build your first project connectors models metrics views what are metrics views underlying model table derived metrics views time series dimensions measures annotations rollups data access control metrics sql dashboards custom apis alerts project configuration ai configuration organize your code files external ide integration debugging in rill developer deploy rill cloud vs rill developer configure deployment credentials deploy dashboards managing project errors embed iframe postmessage api tutorials other release notes home build metrics views on this page 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 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 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 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 performance rollups accelerate queries by routing to pre aggregated rollup tables security data access policies control access to your metrics data with role based permissions previous performance optimization next what are metrics views metrics 101 dimensions measures performance security 2026 rill data inc privacy policy terms of service community policy contributing