Overview

Finds either the min or the max value in each row between specified field

Description

This function allows you to find the minimum or maximum value among the specified fields. Will be executed for each event. The result will be saved in a new field in the original event. You must specify the collection of fields to be searched for, select the minimum/maximum value, and specify the name of the field where the result will be saved.

Function Schema

Examples

For example, we have 3 indicators in an event for different days of the week: Monday, Tuesday, and Wednesday. We need to find the maximum value for these 3 days. To do this, in the function parameters, set Search Type = 'maximum', New Field Name = 'maxValue', Fields For Searching = 'Monday, Tuesday, Wednesday'. As a result the maximum value will be saved in the maxValue field of the original event