Lowest
Last updated
Last updated
Lowest
Returns lowest non-null value from the list of int values. @param default (optional), Type int. If provided none of the input values are non-null, returns default, Input must be a number or list of numbers.
This function is helpful when a user wants to get the lowest value from a dataset (or set of column values).
Step 1: Create an empty lowest_example_1 using AIOps studio as shown in the below screenshot.
Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:
You can copy the below code into your pipeline and execute that in your environment.
##### This pipeline creates a list of rows with various numbers (int values) for various
##### ids using AIOps studio.
##### RDA function lowest is used to demo this example. In this pipeline, each row added
##### has three columns with various numerical values. Pipeline uses RDA dm function
##### lowest to pick the lowest value from set of values and prints that value
##### for each row/id.
@dm:empty
--> @dm:addrow id = 'a1' & x = 10 & y = 3 & z = 9
--> @dm:addrow id = 'a2' & x = 1 & y = 13 & z = 4
--> @dm:addrow id = 'a3' & x = 7 & y = 3 & z = 3
--> @dm:addrow id = 'a4' & x = 4 & y = -1 & z = 9
--> @dm:map to = "MIN_VALUE" & from = "x,y,z" & func = 'lowest'
Step 3: Click verify button to make sure syntax and pipeline code is correct (as shown below)
Step 4: Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)
Step 5: RDA uses the dm function 'lowest' to select the 'lowest' numerical number (or value) from the dataset and map that to variable "MIN_VALUE" and prints the output for each dataset (or row) as shown in the following screenshot.
Similarly, dm: function 'lowest' can be used to select the lowest value(s) from the selected dataset.
