Upsolver SQLake
Contact Support
Search
⌃
K
Links
Overview
Get started
Deploying Upsolver on AWS
Connectors
Data ingestion
Data transformation
Quickstarts
How to guides
SQL command reference
Functions and operators reference
Logical operators and filter functions
Comparison functions and operators
Conditional functions and expressions
Mathematical functions and operators
String functions and operators
Regular expression functions
Date and time functions
Interval functions
Aggregate functions
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT_EACH
AVG
AVG_EACH
AVG_TIME_SERIES
COLLECT_SET
COLLECT_SET_EACH
COUNT
COUNT(*)
COUNT(DISTINCT ...)
COUNT_EACH
COUNT_IF
DYNAMIC_SESSIONS
FIRST
FIRST_ARRAY
FIRST_EACH
FIRST_TIME_SERIES
LAST
LAST_ARRAY
LAST_EACH
LAST_K
LAST_K_EACH
LAST_TIME_SERIES
MAX
MAX_BY
MAX_EACH
MAX_TIME_SERIES
MIN
MIN_BY
MIN_EACH
MIN_TIME_SERIES
SESSION_COUNT
STD_DEV
STD_DEV_EACH
STRING_MAX
STRING_MAX_EACH
STRING_MIN_EACH
SUM
SUM_EACH
SUM_TIME_SERIES
WEIGHTED_AVERAGE
Array functions
URL functions
External APIs functions
Spatial functions
Structural functions
Type conversions functions
System Catalog
Job status
API Integration
CLI
FAQ
Troubleshooting
Upsolver cost estimate
Change log
Powered By
GitBook
Comment on page
WEIGHTED_AVERAGE
The weighted average of a field in the time window.
Syntax
WEIGHTED_AVERAGE
(
VALUE
,
WEIGHT
)
Arguments
VALUE
Type:
numeric
The field to weigh before averaging.
WEIGHT
Type:
numeric
The field giving the corresponding weight for each
VALUE
.
Returns
Type:
numeric
Returns the average of
VALUE
weighed by
WEIGHT
.
Previous
SUM_TIME_SERIES
Next
Array functions
Last modified
1yr ago