Get Statistics from Collection
Description
The Get Statistics from Collection part allows you to pull basic statistics from any data collection. This part allows you to gather from a collection the following statistics: maximum (largest number), minimum (smallest number), average (average number in the collection), number (the count of the collection), and sum (the sum of the collection).
Node Type
This part is available in process nodes and is located in the Collections dropdown menu.
Used With
This part is available in version 7.4.6, revision 34263 and later, and it works with all frameworks and in standalone applications.
Editor Fields
| Field Name | Description/Use | Type/Options | Optional/Mandatory |
| Collection | This is the collection from which the part will pull statistics. | Data Object | Mandatory |
| Key | The key is the variable in the collection that you want to compare. For example, if your collection looks like the following:
You can select score as the key about which to get relevant statistics. |
Data Object | Mandatory |
| Path | The path is the name of the data object to which the system will write the collection results. The part returns the average, maximum, minimum, count and sum of the key values.
In Release 8.2+ the results include the key count, which is the number of occurrences of the specified key in the collection. In the abdominal pain example above, the key_count for qname key should be 1 while key_count for score should be 2. |
Data Object | Mandatory |
Example Project
The get_statistics_from_collection part is demonstrated in the Example tab of the How To Guide - Querying Complex Collections project, available on the Community Portal Shared Workspace (v8.1+) or downloadable from this article.