Preface
RulePoint
RulePoint Concepts
- RulePoint Concepts Overview
- Understanding RulePoint Entities
Using RulePoint
RulePoint Objects
- RulePoint Objects Overview
- State of RulePoint Objects
Working with Topics
Working with Connections
Working with Sources
Working with Responders
Working with Responses
Working with Watchlists
Working with Analytics
- Analytics Overview
- Analytic Types
- Creating an Analytic
- Copying an Analytic
- Editing an Analytic
- Deleting an Analytic
- Viewing Related Objects
- Predefined Analytics
  - abs
  - average
  - ceil
  - charat
  - clean
  - compareto
  - concat
  - confidence
  - correlation
  - count
  - current
  - date
  - datedifference
  - endswith
  - even
  - floor
  - getcurrentdate
  - getdatefrommillis
  - getdateinmillis
  - geodistance
  - geoinbound
  - geoinsidearea
  - geointersect
  - geooutbound
  - geooutsidearea
  - geopassthru
  - indexof
  - integer
  - isblank
  - isholiday
  - isnum
  - istext
  - isweekday
  - isweekend
  - large
  - list2vars
  - lower
  - max
  - min
  - mod
  - mode
  - mround
  - odd
  - parse
  - past
  - percentile
  - power
  - proper
  - range
  - regex
  - replace
  - round
  - rounddown
  - roundup
  - sign
  - small
  - startswith
  - stdev
  - stringequals
  - stringindexof
  - stringlastindexof
  - stringlength
  - substring
  - sum
  - trim
  - truncate
  - upper
  - xpath
- Predefined Operators
  - contains
  - equalsSet
  - has
  - in
  - match
  - notMatch
  - search
  - unique
  - group by
  - distinct
  - unmatched
- Using the distinct, group by, and ummatched Filters
DRQL
Working with Rules
Working with Alerts
Setting Access Controls
Troubleshooting RulePoint Issues
Connecting to an Ultra Messaging Application
Creating an Ultra Messaging JMS Source

User Guide

6.1
- 6.2
- 6.1.2

Back Next

average

The average analytic calculates and returns the average of real numbers.

Syntax

average(number1,[number2],…)

The following table describes the required and optional arguments:

Argument	Required Optional	Description
number1	Required	The real number value for which you want the average value.
number2, ...	Optional	The real number values for which you want the average value.

The following table provides the datatype for the parameters you can pass:

Parameter Input Options	Datatype
Event property	Real number
Watchlist values	Real number

Example

when 3 stockTopic s with  average(s.value) as  result >10 then response with body=”${result} ”

The following table describes the result for the event property value that you pass:

Event Property Value	Description	Result
s.values = 8,12, and 14	Average of three event values must exceed 10.	>10

Error Condition

The analytic does not run when there is a type mismatch, that is, when the values contain nonnumeric data. On type mismatch, the analytic returns an error, stops the rule evaluation, and writes the mismatch error to the log file.

Rename Saved Search

Table of Contents

User Guide

User Guide

average

average

Syntax

Error Condition