# Lowest

**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).

### Example 1: 

Step 1: Create an empty **lowest\_example\_1** using AIOps studio as shown in the below screenshot.

![Empty pipeline](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me8PpYDNgWQ4eDQ4BAg%2F-Me8QAYKDBB7Nn2e8Cbf%2FScreen%20Shot%202021-07-08%20at%209.00.35%20PM.png?alt=media\&token=74b2a8ad-ee07-4c58-89b4-eedaa20a0e9c)

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.\
\
\&#xNAN;*`##### 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'`*<br>

![Pipeline code added to empty pipeline created](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me8SmBZmmQh7wIqn6nf%2F-Me8TBTNA9caBEqCHkJo%2FScreen%20Shot%202021-07-08%20at%209.13.23%20PM.png?alt=media\&token=2cbc352c-8b14-4ea9-b6e8-8da424ef01db)

\
Step 3: Click verify button to make sure syntax and pipeline code is correct (as shown below)

![Pipeilne code is verified using 'Verify' button as shown above.](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me8TL-lEoM1G_cLsXxi%2F-Me8UDgOCOXDICaKUrNh%2FScreen%20Shot%202021-07-08%20at%209.18.15%20PM.png?alt=media\&token=b5997776-0686-46ba-b4fb-1607b319289e)

Step 4:  Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

![Successful execution of pipeline without any errors](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me8UJpeajBGlpGJDGVp%2F-Me8Ugn07FeHHJe-yIfQ%2FScreen%20Shot%202021-07-08%20at%209.20.14%20PM.png?alt=media\&token=d01bbdc7-eada-4b08-93e2-b8773e3a8253)

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.

![Lowest value is printed for each dataset in the MIN\_VALUE](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me8UkPq8-dAK3LsIbPq%2F-Me8V5L7qD0PoNqS0yZY%2FScreen%20Shot%202021-07-08%20at%209.22.02%20PM.png?alt=media\&token=50870bd3-94cc-47f7-9792-8544283a9287)

Similarly, dm: function 'lowest' can be used to select the lowest value(s) from the selected dataset.

&#x20;