LogoLogo
  • Welcome to the MOOST platform user manual
  • Platform Manual
    • Login
      • Forgot Password
    • Notifications
    • Rules
      • Rule Configurator
        • Data graph
        • Datasets
        • Condition
        • Streak
        • Message
        • Settings
        • Rule Simulator
        • Early Adopter
        • Command
      • Rule Language
        • Syntax
        • Data Types
        • Data Structures
        • Functions
          • AVG
          • COUNT
          • DISTINCT
          • EVAL
          • FILTER
          • GROUP_BY_DEVICE
          • GROUP_BY_TIME
          • MAX
          • MIN
          • POSITION
          • REVERSE
          • SORT
          • SUBSET
          • SUM
        • Operations
          • Plus
          • Minus
          • Multiply
          • Divide
          • Negate
          • Less Than
          • Less or Equal
          • Equal
          • Not Equal
          • Greater or Equal
          • Greater
          • AND
          • OR
          • NOT
          • Format
          • Attribute Accessor
        • Examples
    • Events
    • Buildings
      • Household Profile
    • User Profile
    • Billing Portal
      • Payment Method
      • Update Payment Address
      • Invoices
      • Terminate Subscription
    • Context Services
      • Weather Forecast
      • Solar Production Forecast
      • Power Consumption Forecast
      • Power Generation Forecast
    • Support Center
  • Technical Integration
    • Cloud-to-Cloud Integration
      • Platform On-boarding
      • Configure Notification Settings
        • Receive Notifications
          • iOS Notification Handling
      • MOOST API Integration
        • Request Access Token
        • Synchronize Buildings and Devices
          • Device Types
        • Add Events
          • Event Types
            • Device Status
            • Charging Modes
            • Switch State
        • Notifications and Interactions
          • Return Notification Interaction
  • Best Practices
    • FAQ
    • User Acceptance Testing
  • Policies
    • Security Policy
    • Privacy Policy
Powered by GitBook

© 2025 MOOST AG

On this page
  • Description
  • AVG(Vector<Number/Event>)
  • AVG(GroupedScalar<any, Number/Event>)
  • AVG(GroupedVector<any, Number/Event>)
  • Examples
Export as PDF
  1. Platform Manual
  2. Rules
  3. Rule Language
  4. Functions

AVG

Description

Calculates the average on a set of numbers or event values

AVG(Vector<Number/Event>)

AVG(vector: Vector<Number/Event>): Scalar<Number>

Calculate the average as Scalar<any> from the given parameter.

Parameters

Parameter
Description

vector

A vector of type <Number/Event>

Returns

Returns the average as Scalar<Number>

AVG(GroupedScalar<any, Number/Event>)

AVG(group: GroupedScalar<any, Number/Event>): Scalar<Number>

Calculate the average as Scalar<any> from the given parameter.

Parameters

Parameter
Description

group

A GroupedScalar of type <any, Number/Event>

Returns

Returns the average as Scalar<Number>

AVG(GroupedVector<any, Number/Event>)

AVG(group: GroupedVector<any, Number/Event>): GroupedScalar<Number>

Calculate the average as GroupedScalar<any> from the given parameter.

Parameters

Parameter
Description

group

A GroupedVector of type <any, Number/Event>

Returns

Returns the average as Scalar<Number>

Examples

Retrieve the average of the GridPowerConsumption time series.

AVG($GridPowerConsumption)
PreviousFunctionsNextCOUNT

Last updated 1 year ago