rill-metrics-view

Defines and manages metrics views in Rill for data analysis and dashboarding.

47|9|Updated May 17, 2023
One-click install
npx skills add https://github.com/rilldata/rill-examples --skill rill-metrics-view
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rill-metrics-view
Source: https://github.com/rilldata/rill-examples/tree/main/medicaid-provider-spending/.claude/skills/rill-metrics-view
Command: npx skills add https://github.com/rilldata/rill-examples --skill rill-metrics-view

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a structured way to define and manage business metrics within the Rill data platform, enabling consistent data analysis and dashboarding.

Core Features & Use Cases

  • Metrics Definition: Define aggregations, dimensions, and time series for your data.
  • Data Exploration: Power interactive dashboards and custom APIs with defined metrics.
  • Security & Access Control: Implement granular access policies for sensitive data.
  • Use Case: Create a 'Sales Performance' metrics view to track total revenue, unique customers, and conversion rates, filterable by country and product category.

Quick Start

Use the rill-metrics-view skill to define a new metrics view for analyzing order data.

Frequently Asked Questions about rill-metrics-view

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define business metrics and dimensions for dashboarding in Rill?

To define business metrics in Rill, you create a metrics view that specifies aggregations, dimensions, and time series over your data. This semantic layer structures data analysis and powers interactive dashboards.

What is a semantic layer for OLAP databases and when do I need one?

A semantic layer for OLAP databases maps underlying data into defined business metrics, dimensions, and time series. You need one to ensure consistent data exploration, dashboarding, and reporting across your analytics.

Can I implement row-level security and access control for metrics views?

Yes, you can implement granular security and access policies for metrics views. This feature allows you to enforce row-level access control, restricting sensitive data visibility for different users during dashboarding and data exploration.

Does Rill support time-series analysis and custom API generation for business intelligence?

Rill supports time-series analysis by defining temporal aggregations within your metrics view. These defined metrics automatically facilitate data exploration, alerting, reporting, and custom API generation for your business intelligence applications.

What is the best way to model a Sales Performance dashboard tracking revenue and conversion rates?

The best way to model a Sales Performance dashboard is to define a metrics view specifying measures like total revenue and conversion rates. You then add dimensions like country and product category for interactive filtering.

How do I generate custom APIs from defined metrics for data exploration?

You generate custom APIs by defining your aggregations and dimensions within a metrics view. Rill automatically uses this semantic layer to facilitate data exploration, alerting, and custom API generation over your OLAP databases.