Skip to content
Infoveave Help

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

ParameterDescription
ExpressionA placeholder in a function replaced with actual widget and measure names.
Widget NameThe specific name or identifier of the widget used for data visualization.
MeasureThe name of the measure displayed or analyzed using the widget.

Steps to Use AVERAGE

  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.

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

AVERAGE in Calculated Columns

ParameterDescription
ExpressionA placeholder in a function replaced with column names.
Column NameThe name of the column containing the values to analyze.

Steps to Use AVERAGE in Calculated Columns

  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.

Objective Find the average UNIT PRICE from a sales dataset.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03BrazilBaby Food38.4143.78742
2024-01-07JapanSpices45.5650.815520
Japan43.787410
2024-01-1832.30194
2024-01-22BrazilCosmetics28.33523.01097
2024-01-26Canada20.18523.01099
2024-01-04FranceCereal25.2628.79649
2024-01-09BrazilCereal44.57550.81558
2024-01-14BrazilSnacks20.1854
BrazilCosmetics40.48546.15292

Use the AVERAGE function like this

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

The new calculated column “Average Unit Price” will return 26.29

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITYTOTAL QUANTITY
03-01-2024BrazilBaby Food38.4143.7874226.29
07-01-2024JapanSpices45.5650.81552026.29
Japan43.78741026.29
18-01-202432.3019426.29
22-01-2024BrazilCosmetics28.33523.0109726.29
26-01-2024Canada20.18523.0109926.29
04-01-2024FranceCereal25.2628.7964926.29
09-01-2024BrazilCereal44.57550.8155826.29
14-01-2024BrazilSnacks20.185426.29
BrazilCosmetics40.48546.1529226.29