---
title: "Creating Metrics in AI Dashboards"
slug: "r365-intelligence-creating-metrics"
description: "Create custom AI Dashboard metrics using shortcut metrics, Aggregate By functions, or the Formula/Function editor. Set behavior to Manual."
updated: 2026-04-13T16:10:41Z
published: 2026-04-13T16:10:41Z
canonical: "docs.restaurant365.com/r365-intelligence-creating-metrics"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating Metrics in AI Dashboards

This article covers creating metrics and is part of R365 AI Dashboards, an R365 add-on feature.

Metrics are data objects that are used to measure. New metrics can be created by creating new calculations. When created, these are added to the Datasets Panel as a new data object, and they can then be used to create visualizations.

Metrics can be created using system-built shortcuts or from scratch using the Formula/Function editor.

---

## Video - How to Create Your Own Metric

[Embedded content](https://player.vimeo.com/video/1062115129?h=4091d64825&badge=0&autopause=0&player_id=0&app_id=58479)

---

## Shortcut Metric

A metric can be created using the **Shortcut metric** option. This function can be completed by right-clicking a metric on a visualization and selecting **Shortcut metric** from the dropdown options.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-M7JCBRAL.png)

Shortcut metrics are preprogrammed calculations based on the metric selected, including the following:

- Rank
- Percentile Rank
- Percent to Total
- Percent Of
- Percent Change
- Moving Average
- Running Total
- Percent Running Total

Once a selection is made, the metric will appear in the visualization and within the Datasets panel.

---

## Aggregate By

The **Aggregate By** option allows use of the aggregation function, which is used to calculate subtotals for a metric, including the following:

- Sum
- Average
- Minimum
- Maximum
- Count
- Median
- Mode
- Product
- Standard Deviation
- Variance

To access the aggregation function, right-click over a metric and select **Aggregate By** from the dropdown, then make a selection.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-F7NSVD0O.png)

---

## Calculation

A new derived metric can also be created by combining the values of multiple metrics with a calculation. This can be done by right-clicking a metric, then selecting **Calculation** from the dropdown and making the necessary selections.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-B49YZNAA.png)

From the calculation options, the metrics to combine can be selected, along with whether to add, subtract, multiply, divide, or average the selected metrics.

---

## Creating a Metric Using the Formula/Function Editor

In addition to using preprogrammed metric building, a metric can also be created using the Formula/Function editor. To do this, click the menu button from the Datasets panel and select **Create metric** from the dropdown. This will open the Formula/Function editor.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-36D1CEGB.png)

The **Switch to [Function/Formula] Editor** button in the bottom left corner can be clicked to switch to the Formula/Function editor at any time.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-0A4BG0BZ.png)

Click to expand a section for details about each editor.

### Function Editor

From the Function Editor mode, a metric must be built by first selecting a metric function, and then specifying the parameters, such as which existing data object to base the calculation upon. The required information will be dependent on the function selected. When clicked, each function has a description in the bottom panel of the dialog box.

As an example, when creating a metric that represents SPLH, the **Quotient** function as well as **Gross Sales** and **Total Actual Hours** might be selected to complete the required parameters.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/24651d96-f813-44b5-97eb-f82919a3ba36.png)

### Formula Editor

In Formula Editor mode, metrics are created by building out a formula in the formula box. Existing functions and data objects can be utilized to build out the formula, or the formula can be typed out directly. As a formula is typed into the formula box, predictive text helps make selections.

As an example, the formula Total Sales/Actual Hours might be created to represent a metric for SPLH.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/54a54d60-ada4-462e-bb7a-ceacb0ffbb3b(1).gif)

Once the metric is created, the metric behavior must be changed to **Manual**. To do this, click **Metric Options** in the top right corner of the window.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-TOND1FVW.png)

Select **Manual** as the metric behavior. Then click **OK** to close.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-X0FUI51C.png)

Once set to manual, the metric can be saved by clicking **Save**.