Skip to content
Infoveave Help

MINX

The MINX function in Infoveave finds the minimum (smallest) value in a dataset or column based on a specified condition.

Applicable to

  • Calculated Columns
  • Expressions

Return Value

The minimum value in the related table of the widget that satisfies the condition.

Remark

  • MINX is useful for finding the smallest value under specific conditions.
  • MINX excludes nulls and blanks.
  • MINX works with Dates, Strings, and Numbers.

Syntax

MINX(<Reference>,<Condition>)

MINX in Board Expression

ParameterDescription
ExpressionPlaceholder replaced with the condition filter.
Widget NameSpecific name of the widget used for data visualization in the Infoboard.
MeasureName of the measure displayed or analyzed using the widget.
DimensionDimension column displayed or analyzed using the widget.
Dimension ValueSpecific dimension items within the dimension column used for widget visualization.

Steps to Use MINX

  1. Write the MINX function. For instance MINX(<expression>,<condition>)
  2. Replace <expression> with 'Widget Name'[Measure] and <condition> with [Dimension Name]="Dimension Value". Replace Widget Name, Measure, Dimension Name, and Dimension Value with your actual values.
  3. To learn how to configure an Expression in Infoveave, visit Configure Expression.

Scenario You manage a solar energy company’s customer database, including discount information. Your goal is to optimize discounts while ensuring a minimum number of customers receive a “Guaranteed” discount.

Scenario Details

  • Dashboard Name Solar Energy Management Dashboard
  • Widget Name Solar Feed In
  • Measure Name Solar Customers
  • Dimension Name Discount Types
  • Dimension Values “Guaranteed”

Objective Find the minimum number of solar customers who must have the “Guaranteed” discount type. If yes it must trigger an action.

  • You can use the MINX function like this
MINX('Solar Feed In'[Solar Customers], [Discount Types]="Guaranteed") > 10

MINX in Calculated Columns

ParameterDescription
ExpressionPlaceholder replaced with the condition filter.
Column NameName of the column containing values to analyze.
Filter ConditionFilter condition (string or numeric) that returns data points to analyze.

Steps to Use MINX in Calculated Columns

  1. Write the MINX function. For instance MINX(<expression>,<condition>)
  2. Replace <expression> with [Column Name] and <condition> with [Column Name]="Filter Condition". Replace Column Name and Filter Condition with your actual values.
  3. To learn how to add calculated columns in Infoveave, visit Calculated Columns under Sources.

Objective Find the minimum MARKET PRICE for COUNTRY = Brazil in a sales dataset.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03BrazilBaby Food38.4143.78742
2024-01-07JapanSpices45.5650.815520
Japan43.787410
2024-01-1832.30194
2024-01-22BrazilCosmetics28.33523.01097
2024-01-26Canada20.18523.01099
2024-01-04FranceCereal25.2628.79649
2024-01-09BrazilCereal44.57550.81558
2024-01-14BrazilSnacks20.1854
BrazilCosmetics40.48546.15292
  • You can use the MINX function like this
MINX([MARKET PRICE], [COUNTRY] = "Brazil")

The calculated column “Min Market Price” will return 23.0109.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITYMIN MARKET PRICE
03-01-2024BrazilBaby Food38.4143.7874223.0109
07-01-2024JapanSpices45.5650.81552023.0109
Japan43.78741023.0109
18-01-202432.3019423.0109
22-01-2024BrazilCosmetics28.33523.0109723.0109
26-01-2024Canada20.18523.0109923.0109
04-01-2024FranceCereal25.2628.7964923.0109
09-01-2024BrazilCereal44.57550.8155823.0109
14-01-2024BrazilSnacks20.185423.0109
BrazilCosmetics40.48546.1529223.0109