Definition:
- The MIN function in Infoveave is used to find the minimum (smallest) value within a column (Measure).
Applicable to:
Calculated Columns Expressions
Return Value:
- The return value of the MIN function is the smallest value found within the specified column.
Remark:
- MIN is useful when you want to determine the smallest value in a dataset, helping you identify the lowest value among a set of data points.
- MIN function returns the minimum value in the column, excluding nulls and blanks.
- MIN function can be used across Dates, Strings, and Numbers
Syntax:
MIN(<expression>)
Tip
- The MIN function applied to a date column will return the earliest date entry.
- The MIN function applied to string values, will return the first value based on alphabetical order.
- The MIN function applied to a Boolean, will return the FALSE.
MIN in Board Expression
Note
Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.
Parameters
Expression | A placeholder in a function that is replaced with the actual widget and measure names. |
Widget Name | The specific name or identifier of the widget being used for data visualization in the specific Infoboard. |
Measure | Represents the name of the measure that is being displayed or analyzed using the widget. |
- Write the MIN function. For instance:
MIN (<expression>)
- Replace
<expression>
with'Widget Name'[Measure]
- Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
- To learn how to configure an Expression in Infoveave, visit the section Configure Expression.
Example
Scenario:
- Your primary objective is to identify the product with the lowest price from a wide range of products listed in your 'Product Prices' dataset. Moreover, you aim to ensure that this product's price doesn't go below a certain threshold, which, in this case, is set at $50.
- Dashboard Name: E-commerce Bargain Finder
- Widget Name: Product Prices
- Measure Name: Price (representing the price of products)
- You can use the MIN function like this:
MIN('Product Proces'[Price]) <= 50
MIN in Calculated Columns
Parameters
Expression | A placeholder in a function that is replaced with the actual widget and measure names. |
Column Name | The name of the column in the dataset or Datasource that contains the values you want to analyze. |
- Write the MIN function. For instance:
MIN(<expression>)
- Replace
<expression>
with the[Column Name]
in the dataset. - To learn how to use Infoveave functions in calculated columns, visit Add Calculated Column under Sources.
Example
Objective: Consider that you have the below sales dataset, your goal is to find the min entry value under MARKET PRICE.
ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY |
2024-01-03 | Brazil | Baby Food | 38.41 | 43.7874 | 2 |
2024-01-07 | Japan | Spices | 45.56 | 50.8155 | 20 |
Japan | 43.7874 | 10 | |||
2024-01-18 | 32.3019 | 4 | |||
2024-01-22 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 |
2024-01-26 | Canada | 20.185 | 23.0109 | 9 | |
2024-01-04 | France | Cereal | 25.26 | 28.7964 | 9 |
2024-01-09 | Brazil | Cereal | 44.575 | 50.8155 | 8 |
2024-01-14 | Brazil | Snacks | 20.185 | 4 | |
Brazil | Cosmetics | 40.485 | 46.1529 | 2 |
- You can use the MIN function like:
MIN([MARKET PRICE])
ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | MIN MARKET PRICE |
03-01-2024 | Brazil | Baby Food | 38.41 | 43.7874 | 2 | 23.0109 |
07-01-2024 | Japan | Spices | 45.56 | 50.8155 | 20 | 23.0109 |
Japan | 43.7874 | 10 | 23.0109 |
|||
18-01-2024 | 32.3019 | 4 | 23.0109 |
|||
22-01-2024 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 | 23.0109 |
26-01-2024 | Canada | 20.185 | 23.0109 | 9 | 23.0109 |
|
04-01-2024 | France | Cereal | 25.26 | 28.7964 | 9 | 23.0109 |
09-01-2024 | Brazil | Cereal | 44.575 | 50.8155 | 8 | 23.0109 |
14-01-2024 | Brazil | Snacks | 20.185 | 4 | 23.0109 |
|
Brazil | Cosmetics | 40.485 | 46.1529 | 2 | 23.0109 |