---
title: AVERAGE
description: Learn how to use the AVERAGE function for calculating averages in dashboards, with detailed syntax, examples, and scenarios for effective data analysis and visualization.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# AVERAGE

The AVERAGE function in Infoveave calculates the average of values in a specified dataset or column.

## Applicable to

* Calculated Columns
* Expressions

## Return Value

The sum of all values in the specified dataset or column.

## Remark

* Used only for numeric values.
* Useful for deriving average values.
* Cannot be used across dates and strings.
* Neglects null and blank values.

## Syntax

```
AVERAGE(<expression>)
```

## AVERAGE in Board Expression

<Aside>
Expressions add visual effects to your dashboard through widget-specific conditions. They are not for managing or modifying data.
</Aside>

| Parameter      | Description                                                                                                    |
|----------------|----------------------------------------------------------------------------------------------------------------|
| Expression     | A placeholder in a function replaced with actual widget and measure names.                                     |
| Widget Name    | The specific name or identifier of the widget used for data visualization.                                     |
| Measure        | The name of the measure displayed or analyzed using the widget.                                                |

Steps to Use AVERAGE

<Steps>
1. Write the AVERAGE function. **For instance** `AVERAGE(<expression>)`
2. Replace `<expression>` with `'Widget Name'[Measure]`.Replace **Widget Name** with your widget's name and **Measure** with the measure name.
3. To configure an Expression in Infoveave, see [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions).
</Steps>

<div role="alert">

**Scenario** Calculating the average of customers and triggering an action if the average is less than 1000000.

**Scenario Details**

* **Dashboard Name** Energy Management Dashboard
* **Widget Name** Total Customer
* **Measure Name** Total Customers (total number of customers)

**Objective** Track the average customer count and take action if it exceeds or falls below a threshold.

Use the AVERAGE function like this

```
(AVERAGE('Total Customer'[TotalCustomers])) < 1000000
```
</div>

## AVERAGE in Calculated Columns

| Parameter      | Description                                                                                                    |
|----------------|----------------------------------------------------------------------------------------------------------------|
| Expression     | A placeholder in a function replaced with column names.                                                        |
| Column Name    | The name of the column containing the values to analyze.                                                       |

Steps to Use AVERAGE in Calculated Columns

<Steps>
1. Write the AVERAGE function. For instance `AVERAGE(<expression>)`
2. Replace `<expression>` with `[Column Name]`.Replace **Column Name** with your column's name.
3. To add calculated columns in Infoveave, see [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>

<div role="alert">

**Objective** Find the average UNIT PRICE from a sales dataset.

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY |
|------------|---------|----------|------------|--------------|----------|
| 2024-01-03 | Brazil  | Baby Food| 38.41      | 43.7874      | 2        |
| 2024-01-07 | Japan   | Spices   | 45.56      | 50.8155      | 20       |
|            | Japan   |          |            | 43.7874      | 10       |
| 2024-01-18 |         |          |            | 32.3019      | 4        |
| 2024-01-22 | Brazil  | Cosmetics| 28.335     | 23.0109      | 7        |
| 2024-01-26 | Canada  |          | 20.185     | 23.0109      | 9        |
| 2024-01-04 | France  | Cereal   | 25.26      | 28.7964      | 9        |
| 2024-01-09 | Brazil  | Cereal   | 44.575     | 50.8155      | 8        |
| 2024-01-14 | Brazil  | Snacks   | 20.185     |              | 4        |
|            | Brazil  | Cosmetics| 40.485     | 46.1529      | 2        |

Use the AVERAGE function like this

```
ROUND(AVERAGE([UNIT PRICE]),2)
```

The new calculated column "Average Unit Price" will return 26.29

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | TOTAL QUANTITY |
|------------|---------|----------|------------|--------------|----------|----------------|
| 03-01-2024 | Brazil  | Baby Food| 38.41      | 43.7874      | 2        | 26.29          |
| 07-01-2024 | Japan   | Spices   | 45.56      | 50.8155      | 20       | 26.29          |
|            | Japan   |          |            | 43.7874      | 10       | 26.29          |
| 18-01-2024 |         |          |            | 32.3019      | 4        | 26.29          |
| 22-01-2024 | Brazil  | Cosmetics| 28.335     | 23.0109      | 7        | 26.29          |
| 26-01-2024 | Canada  |          | 20.185     | 23.0109      | 9        | 26.29          |
| 04-01-2024 | France  | Cereal   | 25.26      | 28.7964      | 9        | 26.29          |
| 09-01-2024 | Brazil  | Cereal   | 44.575     | 50.8155      | 8        | 26.29          |
| 14-01-2024 | Brazil  | Snacks   | 20.185     |              | 4        | 26.29          |
|            | Brazil  | Cosmetics| 40.485     | 46.1529      | 2        | 26.29          |
</div>