Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input data

The input data window shows the raw data received by the Data aggregator from the previous functions in the stream. This view can help you to verify the incoming data that will be used for aggregation. There are two tab views available, Table and Tree.

...

Output data

The Output data shows a subset of the aggregated data. It will show the data grouped and summarized based on the criteria set in the aggregator's configuration, for example, total consumption, number of occurrences, or maximum values for each group. It will allow you to inspect the final aggregated data and verify that the function has correctly applied the aggregation rules based on the configuration.

...

Info

Example - Configuration, input, and output data from the sample stream ‘Printing As A Service’.

In the example stream Printing As A Service, the data has been configured to be aggregated by the field printerId, with the SUM of the field 'sheets' and based on the monthly timestamp. This means that the output data will show the total number of sheets (SUM sheets) for each printer (printerId) over one month (timestamp, month).

Printing_as_a_service_DA_config.png

Metadata

There may be instances where you want to apply certain rules to aggregated data, such as applying a discount or adjusting values based on specific business rules. You can achieve this by using the Script function. If you need to reference metadata from aggregated sessions, such as the number of records or timestamps, you can access it using the meta-variable as described in Supported Variables/APIs.

Info

Example- metadata for an aggregated session

Code Block
{"origin":"Data_Aggregator","count":7,"flushType":"TIMEOUT","firstEvent":"2022-04-08T17:35:53.239Z","lastEvent":"2022-04-08T17:38:17.315Z","lastCall":false}

...

Property name 

...

Description

...

count

...

Number of aggregated records

...

flushType

...

The reason for the session being flushed out. Shows any of the values: ALL_FILES, EACH_FILE, TIMEOUT, and CONDITION. During preview, the value will be empty.

...

firstEvent

...

Date and time of the first aggregated record in the session

...

lastEvent

...

Date and time of the last aggregated record in the session