Metric Skill

This skill helps the AI Assistant create MAQL metrics. Use it when you want to define a new metric, write a MAQL expression, create a calculated measure, or build a business KPI.

How It Works

The Metric skill enables the AI Assistant to create MAQL (Multidimensional Analytical Query Language) metrics. When activated, the assistant:

1. Searches for existing metrics, facts, and attributes using semantic search
2. Understands the user’s metric definition requirements
3. Generates appropriate MAQL expressions
4. Creates the metric using the MAQL creation API
5. 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
The user asks: Create a metric for gross margin.
The AI Assistant then:

• finds the relevant revenue and cost facts or metrics,
• generates a MAQL expression (for example, (Revenue - Cost) / Revenue), and
• creates and validates the metric.

Building a Calculated Measure
The user asks: Create a metric that calculates average order value.
The AI Assistant then:

• finds the metrics or facts needed (for example, Revenue and Order Count),
• builds the MAQL expression, and
• creates and validates the metric.

Writing a MAQL Expression
The user asks: Create a metric for year-over-year growth percentage.
The AI Assistant then:

• identifies the base metric to compare,
• applies time comparison logic in MAQL, and
• creates and validates the metric.

More Example Prompts

• Define a KPI for customer lifetime 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