Metric Skill
Create MAQL metrics. Use this skill when users want to define new metrics, write MAQL expressions, create calculated measures, or build business KPIs.
Experimental Feature
This is an experimental feature that is still under active development. Its behavior may change in future releases, or the feature may be removed.
How It Works
The Metric skill enables the AI Assistant to create MAQL (Multidimensional Analytical Query Language) metrics. When activated, the assistant:
- Searches for existing metrics, facts, and attributes using semantic search
- Understands the user’s metric definition requirements
- Generates appropriate MAQL expressions
- Creates the metric using the MAQL creation API
- Validates the metric and confirms it works correctly
The skill uses existing MAQL creation rules and patterns, ensuring consistency with platform standards. It can create simple calculated metrics as well as complex expressions involving multiple facts, attributes, and functions.
Examples
Creating a simple metric:
User: "Create a metric for gross margin"
Assistant: [Searches for Revenue and Cost facts, generates MAQL: (Revenue - Cost) / Revenue, creates metric]Building a calculated measure:
User: "Create a metric that calculates average order value"
Assistant: [Finds Revenue and Order Count metrics, creates MAQL expression, validates]Writing MAQL expression:
User: "Create a metric for year-over-year growth percentage"
Assistant: [Uses time functions, creates MAQL with period comparisons, creates metric]Other use cases:
- “Define a KPI for customer lifetime value”
- “Create a metric that calculates (Revenue - Cost) / Revenue”
- “Write a MAQL expression for year-over-year growth”
- “Create a calculated field for average order value”
- “Build a metric that shows percentage of total”
Limitations
- Requires appropriate permissions to create metrics in the workspace
- Metric creation depends on available facts and attributes in the logical data model
- Complex metrics may require clarification of business logic