aggregates
relationalai.semantics.std
Aggregation functions for relational operations.
This module provides functions for aggregating data including:
- Statistical aggregates
- String aggregation
- Ranking and sorting
- Ordering modifiers
- Grouped aggregations
Functions
Functions exposed by this module.
sum()Compute the sum of values.
count()Count the number of values.
min()Find the minimum value.
max()Find the maximum value.
avg()Compute the average of values.
string_join()Join string values with a separator.
asc()Specify ascending order for values in sorting and ranking operations.
desc()Specify descending order for values in sorting and ranking operations.
rank()Compute rank based on the ordering of values.
limit()Limit results based on ordering.
rank_asc()Compute rank in ascending order.
rank_desc()Compute rank in descending order.
top()Get the top N results in descending order.
bottom()Get the bottom N results in ascending order.
cumsum_asc()Compute cumulative sum in ascending order.
per()Create a grouped aggregation context.
Classes
Classes exposed by this module.
PerGroup aggregation context for computing per-group aggregates.