📏 What Is a Metric?

Turn raw data into meaningful insights with calculated metrics in Advanced Analytics

🧭 Overview

A metric is a calculated expression of numerical data — typically built from facts, attributes or even other metrics.

In Advanced Analytics, metrics define what you’re measuring. You’ll use them to calculate values like:

Total number of completed tasks
Average response value for 1-to-1s

Metrics are the foundation of all visualisations and dashboards — they drive the numbers you see.

⚙️ How Metrics Work

Metrics are written using MAQL (Multi-Dimension Analytical Query Language), the language used within the Advanced Analytics tool (similar to SQL).

With MAQL, you can:

Calculate totals, averages, percentages, ratios and more
Apply filters and conditional logic (e.g. only include active users or completed tasks)

🧩 Examples

Use Case	Example Metric	Description

Use Case	Example Metric	Description
Track active user count in your platform	Count of Active users `SELECT COUNT({label/users.id}) WHERE {label/users.deactivated} = "false"`	Returns the number of users who have not been deactivated. Ideal for tracking your active user base over time or across segments.
Monitor overall task completion rate	Percentage of completed tasks `SELECT IFNULL((SELECT COUNT({label/tasks.id}) WHERE {label/tasks.completed} = "true"), 0) / (SELECT COUNT({label/tasks.id}))`	Calculates the proportion of tasks that have been completed out of the total. Useful for assessing content engagement or workflow completion rates.
Measure completion rates for issued 1-to-1 meetings	Completion rate for 1-to-1s `SELECT IFNULL((SELECT COUNT({label/one_to_ones.id}) WHERE {label/one_to_ones.status} = "completed"), 0) / (SELECT COUNT({label/one_to_ones.id}))`	Measures how many 1-to-1s have been marked as completed out of all issued. Helps evaluate follow-through on manager check-ins or coaching sessions.
Compare average skill ratings across teams or managers	Average skill rating by manager `SELECT AVG({fact/managerrating})`	Calculates the average value of manager-assigned skill ratings. Useful for comparing performance feedback across teams, managers, or skills.

🏗️ Centrally Created Metrics (Use or Customise)

Learn Amp provides a collection of centrally created metrics — built by our team to help you get started quickly.

These metrics:

Are available by default in your Advanced Analytics environment
Cover high-value use cases (e.g. completions, count of users, 1-to-1s, Objectives etc)
Can be used as-is or copied and adapted to your needs

You can:

Use them directly in dashboards and reports
Copy and customise them to create tailored versions, including specific conditional formatting (e.g. decimal places, percentage display, currency)

⚠️ Important:
Any changes you make directly to a centrally created metric will be overwritten by our daily refresh mechanism.
To customise, always create a copy of the metric first — then make your edits to the copy.
Use the description field to add descriptive notes on what the metric is about and what should it be used for.

🛠️ Creating Your Own Metrics

When you need something unique, you can build your own metrics using MAQL.

👉 Learn more: MAQL Basics
If in doubt or stuck, reach out to us, describe what you are trying to achieve in your report in as much details as possible, and we’ll be able to help.

📅 Last Reviewed: 11 Nov 2025