Deprecation Notice

This Pre-Built has been deprecated as of 01-15-2024 and will be end of life on 01-15-2025. The capabilities of this Pre-Built have been replaced by the IAP - Data Manipulation

Aggregate Functions For Arrays

Table of Contents

• Overview
• Installation Prerequisites
• How to Install
• How to Run
• Attributes
• Examples
• Additional Information

Overview

This JST allows IAP users to pass in an array of numbers and run a set of mathematical aggregate functions on the items. Users can also use this JST on the aggregated arrays returned by the GroupBy Property pre-built. The aggregate functions supported are:

The JST expects all the items in the array to be either numbers or parsable number strings (which will be converted to numbers); however, if there is a non-number/non-parsable string item, the item will simply be ignored from all calculations and returned as part of the valuesIgnored array. Values which are used in calculations will be returned in the valuesUsed array in their original forms (as strings/numbers) and in the valuesUsed-converted array in their converted forms (all numbers).

Installation Prerequisites

Users must satisfy the following prerequisites:

• Itential Automation Platform: ^2021.2.x

How to Install

To install the pre-built:

• Verify you are running a supported version of the Itential Automation Platform (IAP) as listed above in the Prerequisites section.
• The pre-built can be installed from within App-Admin_Essential. Simply search for the name of your desired pre-built and click the install button.

How to Run

Use the following to run the pre-built:

1. Once the JST is installed as outlined in the How to Install section above, navigate to the section in your workflow where you would like to perform aggregations on an array and add a JSON Transformation task.

2. Inside the Transformation task, search for and select aggregateFunctions (the name of the internal JST).

3. After selecting the task, the transformation dialog will display. The inputs to the JST would be the array on which the aggregate functions have to be executed.

4. The output of the JST can be used in any task in the workflow builder that comes after the JSON Transformation task.

5. Save your input and outputs and the task is ready to run inside of IAP.

Attributes

Attributes for the pre-built are outlined in the following tables.

Input

Output

Examples

Below are examples describing how the pre-built will work for different inputs.

Example 1

Input

[
    1,
    "2",
    "3.3",
    4.7,
    5
]

Output

{
  "valuesIgnored": [],
  "valuesUsed": [
    1,
    "2",
    "3.3",
    4.7,
    5
  ],
  "valuesUsed-converted": [
    1,
    2,
    3.3,
    4.7,
    5
  ],
  "count": 5,
  "mode": [
    1,
    2,
    5,
    3.3,
    4.7
  ],
  "modeFrequency": 1,
  "median": 3.3,
  "geometricMean": 2.7423467009186018,
  "product": 155.1,
  "harmonicMean": 2.256525154945151,
  "sum": 16,
  "maximum": 5,
  "minimum": 1,
  "arithmeticMean": 3.2,
  "standardDeviation": 1.5349267083479916,
  "variance": 2.3560000000000003,
  "range": 4
}

Example 2

Input

[
    10,
    "20.",
    "30b",
    null,
    20,
    ".40",
    false,
    [23],
    10,
    50
 ]

Output

{
  "valuesIgnored": [
    "30b",
    null,
    false,
    [23]
  ],
  "valuesUsed": [
    10,
    "20.",
    20,
    ".40",
    10,
    50
  ],
  "valuesUsed-converted": [
    10,
    20,
    20,
    0.4,
    10,
    50
  ],
  "count": 6,
  "mode": [
    10,
    20
  ],
  "modeFrequency": 2,
  "median": 15,
  "geometricMean": 9.63492483998996,
  "product": 800000,
  "harmonicMean": 2.127659574468085,
  "sum": 110.4,
  "maximum": 50,
  "minimum": 0.4,
  "arithmeticMean": 18.400000000000002,
  "standardDeviation": 15.646085772486357,
  "variance": 244.79999999999998,
  "range": 49.6
}

Additional Information

Please use your Itential Customer Success account if you need support when using this Pre-Built Transformation.