Skip to main content
Version: Streamsheets 2.5

MONGO.AGGREGATE

Gets aggregated data from your Mongo database. You can use the Function Wizard to create this function. Operators for the query aggregations can be found here.

Syntax

=MONGO.AGGREGATE(Producer, Collection, Aggregate JSON, Target, [Result Keys], [Timeout])

Arguments

NameDescription
ProducerProducer to use for aggregating. The database name is configured in the affiliated Connector.
CollectionChoose an existing collection, where the items are stored.
Aggregate JSONDefine an aggregation using a JSON cell range.
TargetINBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
Result Keys (optional)Filter the result.
Timeout (optional)Define Timeout.

Return

TRUE, if no error.

Examples

FormulaResultComment
=MONGO.AGGREGATE(|MongoProd,B66, JSON(E67:F76),A73:C78)
In A73:C78Divides the result in two groups, which calculate the total sales above 1500 Euro.