Data Aggregator
Category: Transform
Group and aggregate data with sum, avg, count, min, max operations
What this node does
- Group by multiple fields
- Sum/avg/count/min/max
- Nested aggregations
How to use
- In the Hydra Builder, open or create a workflow
- In the node palette on the left, find Data Aggregator under the Transform category (or use the search bar)
- Drag the node onto the canvas
- Double-click the node to open its configuration dialog
- Fill in the required parameters (see Configuration below)
- Connect the Input Data and Group By Field and Aggregation Operations input port from an upstream node
- Connect the Aggregated Results output to the next node downstream
Inputs
| Port | Type | Required | Description |
|---|---|---|---|
| Input Data | array | ✓ | A list of items |
| Group By Field | text | ✓ | Plain text string |
| Aggregation Operations | array | ✓ | A list of items |
Outputs
| Port | Type | Description |
|---|---|---|
| Aggregated Results | array | A list of items |
Configuration
Open the configuration dialog by double-clicking the Data Aggregator node on the canvas.
| Parameter | What to enter |
|---|---|
groupBy | Configure groupBy in the node settings |
aggregations | Configure aggregations in the node settings |
sortBy | Configure sortBy in the node settings |
When to use this node
- Sum vitals by patient
- Average lab values
- Count encounters by department
Need help configuring this node?
Go to Settings → Connectors to set up the connection this node depends on, then reference the connector ID in the node configuration dialog.