--- title: "How to: Find the Lowest Value Using the Min By Function" slug: "aggregate-operator-min-by" updated: 2025-12-23T15:19:56Z published: 2025-12-23T15:19:56Z canonical: "docs.unqork.io/aggregate-operator-min-by" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.unqork.io/llms.txt > Use this file to discover all available pages before exploring further. # How to: Find the Lowest Value Using the Min By Function UDesignerClassic Designer To identify the lowest value in a data set, use the **Aggregate operator**’s Min By function. ## Configuration Let’s say you have a [Data Table](https://docs.unqork.io/docs/data-table-component) component containing a list of dogs and their ages, and wish to determine the youngest dog to ensure they receive additional playtime. You can configure a [Data Workflow](https://docs.unqork.io/docs/data-workflow-component) and an [Aggregate](/v1/docs/aggregate-operator) operator to return the name of the youngest dog. > [!NOTE] > These instructions assume you have a new module open, saved, and with a title. ### Configure the Data Table Component Begin by adding a [Data Table](/v1/docs/data-table-component) component to store your sample dog data. 1. In the Module Builder, drag and drop a **Data Table** component onto your canvas. 2. In the **Property ID**, enter `dtDogs`. 3. In the data table, enter the following: | name | age | | --- | --- | | Ivy | 7 | | Lucy | 10 | | Wally | 1 | | Nacho | 5 | | Thor | 5 | | Holly | 13 | ![A static image displaying the Data table listing dog names and their corresponding ages for reference.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBy_DataTable.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 4. Click **Save Component**. ### Configure the Data Workflow Component Next, configure a [Data Workflow](/v1/docs/data-workflow-component) component and an [Input](/v1/docs/input-operator) operator to bring in the data from the [Data Table](/v1/docs/data-table-component) component. Then, add an [Aggregate](/v1/docs/aggregate-operator) operator to find the youngest dog. Lastly, you’ll add a [Console](/v1/docs/console-operator) operator to view the results in the DevTools Console. 1. Drag and drop a **Data Workflow** onto your canvas, placing it below your `dtDogs` **Data Table** component. 2. In the **Property ID** and **Canvas Label Text** fields, enter `dwfYoungest`. #### Configure the Input Operator 1. Drag and drop an **Input** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Input | | Component | dtDogs | | Required | Yes | | Source | Default | #### Configure the Aggregate Operator 1. Drag and drop an **Aggregate** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Aggregate By | | Label | Youngest Dog | | Aggregation Type | Min By | | Join Group Keys | No | | Group Key | | | Value Key | age | 3. Connect the output port (right) of the `dtDogs` **Input** operator to the input port (left) of the `Youngest Dog` **Aggregate** operator. #### Configure the Console Operator 1. Drag and drop a **Console** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Console | | Label | Who is the youngest dog? | 3. Connect the output port (right) of the `Youngest Dog` **Aggregate** operator to the input port (left) of the `Who is the youngest dog?` **Console** operator. ![A static image displaying the Data workflow configuration showing property ID and console for youngest dog query.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBy_DataWorkflow.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 4. Click **Save Component**. ### Configure the Button Component Lastly, configure a [Button](https://docs.unqork.io/docs/how-to-guide-button-component) component to trigger your Data Workflow. 1. Drag and drop a **Button** component onto your canvas, placing it below your `dwfYoungest` **Data Workflow** component. 2. In the **Property ID** field, enter `btnYoungestDog`. 3. In the **Label Text** field, enter `Find Youngest Dog`. 4. From the **Action Type** drop-down, select **Event**. 5. From the **On Click** drop-down, select **dwfYoungest**. ![A static image displaying the Button labeled 'Find Youngest Dog' with action triggers for event handling.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBY_Button.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 6. Click **Save Component**. 7. Save your module. Here's how your completed module looks in the Module Builder: ![A static image displaying the Module Builder Configuration a database query for finding the youngest dog in a list.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBy_MB.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) Preview your module in Express View and open the DevTools Console. Click the **Find Youngest Dog** button, and you'll see the youngest dog from your `Who is the youngest dog?` **Console**. ![A static image displaying the DevTools Console output showing the youngest dog named Wally with age information.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBy_Preview.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) To identify the lowest value in a data set, use the **Aggregate operator**’s Min By function. ## Configuration Let’s say you have a [Data Table](https://docs.unqork.io/docs/data-table-component) component containing a list of dogs and their ages, and wish to determine the youngest dog to ensure they receive additional playtime. You can configure a [Data Workflow](https://docs.unqork.io/docs/data-workflow-component) and an [Aggregate](/v1/docs/aggregate-operator) operator to return the name of the youngest dog. > [!NOTE] > These instructions assume you have a new module open, saved, and with a title. ### Configure the Data Table Component Begin by adding a [Data Table](/v1/docs/data-table-component) component to store your sample dog data. 1. In the Module Builder, drag and drop a **Data Table** component onto your canvas. 2. In the **Label** and **Property Name** fields, enter `dtDogs`. 3. In the data table, enter the following: | name | age | | --- | --- | | Ivy | 7 | | Lucy | 10 | | Wally | 1 | | Nacho | 5 | | Thor | 5 | | Holly | 13 | ![A static image displaying the Data table displaying dog names and their corresponding ages for reference.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/CD_AggregateMinBy_DataTable.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 4. Click **Save**. ### Configure the Data Workflow Component Next, configure a [Data Workflow](/v1/docs/data-workflow-component) component and an [Input](/v1/docs/input-operator) operator to bring in the data from the [Data Table](/v1/docs/data-table-component) component. Then, add an [Aggregate](/v1/docs/aggregate-operator) operator to find the youngest dog. Lastly, you’ll add a [Console](/v1/docs/console-operator) operator to view the results in the DevTools Console. 1. Drag and drop a **Data Workflow** onto your canvas, placing it below your `dtDogs` **Data Table** component. 2. In the **Canvas Label Text** and **Property Name** fields, enter `dwfYoungest`. #### Configure the Input Operator 1. Drag and drop an **Input** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Input | | Component | dtDogs | | Required | Yes | | Source | Default | #### Configure the Aggregate Operator 1. Drag and drop an **Aggregate** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Aggregate By | | Label | Youngest Dog | | Aggregation Type | Min By | | Join Group Keys | No | | Group Key | | | Value Key | age | 3. Connect the output port (right) of the `dtDogs` **Input** operator to the input port (left) of the `Youngest Dog` **Aggregate** operator. #### Configure the Console Operator 1. Drag and drop a **Console** operator onto your Data Workflow canvas. 2. Configure the operator's **Info** window as follows: | Setting | Value | | --- | --- | | Category | Console | | Label | Who is the youngest dog? | 3. Connect the output port (right) of the `Youngest Dog` **Aggregate** operator to the input port (left) of the `Who is the youngest dog?` **Console** operator. ![A static image displaying the Data workflow configuration showing input, aggregate, and console components for finding the youngest dog.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/CD_AggregateMinBy_DataWorkflow.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 4. Click **Save**. ### Configure the Button Component Lastly, configure a [Button](https://docs.unqork.io/docs/how-to-guide-button-component) component to trigger your Data Workflow. 1. Drag and drop a **Button** component onto your canvas, placing it below your `dwfYoungest` **Data Workflow** component. 2. In the **Property ID** field, enter `btnYoungestDog`. 3. In the **Label Text** field, enter `Find Youngest Dog`. 4. Set the **Action Type** as **Event**. 5. From the **On Click** drop-down, select **dwfYoungest**. ![A static image displaying the button configuration for finding the youngest dog with action triggers and user feedback.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/CD_AggregateMinBy_Button.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) 6. Click **Save & Close**. 7. Save your module. Here's how your completed module looks in the Module Builder: ![A static image displaying the Module Builder configuration for dog data and a button to find the youngest dog.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/CD_AggregateMinBy_MB.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) Preview your module in Express View and open the DevTools Console. Click the **Find Youngest Dog** button, and you'll see the youngest dog from your `Who is the youngest dog?` **Console**. ![A static image displaying the DevTools Console output showing the youngest dog named Wally with age information.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UD_AggregateMinBy_Preview.jpg?sv=2026-02-06&spr=https&st=2026-11-07T17%3A57%3A48Z&se=2026-11-07T18%3A57%3A48Z&sr=c&sp=r&sig=EYtRgEXGO%2BhnV%2BZXTWpiFGDqYTuFXS%2FP0V%2BY6kFVlHg%3D) A Property ID is the unique field ID used by Unqork to track and link components in your module. The DevTools Console helps you securely store, build, test, and deploy your software. Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the . Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. Triggers activate another component when certain requirements are met. Trigger types include Concurrent, Post, and Error. Some components do not have the ability to trigger others. Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. The action performed by the button when selected. DOM (Document Object Model) events are signals or notifications that something has occurred or is occurring within a web page, often triggered by user interactions or by the browser itself. These events allow JavaScript to react to changes and interactions on a web page, making it dynamic and interactive. Enter the Property ID of the component that you want to trigger on each button-click. Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View. A Property ID is the unique field ID used by Unqork to track and link components in your module.