MAXX

The MAXX function in Infoveave is used to find the maximum (largest) value within the specified column, based on a specified condition defined by the argument.

Applicable to

Calculated Columns
Expressions

Return Value

The return value of the MAXX function is the largest value found within the specified column over the applied condition.

Remark

MAXX is particularly useful when you need to find the maximum value under specific conditions within your data, allowing you to make conditional calculations based on criteria.

Syntax

MAXX(<Reference>,<Condition>)

MAXX in Board Expression

Parameter	Description
Expression	A placeholder in a function that is replaced with the actual widget and measure names.
Condition	A placeholder in a function that is replaced with the condition filter.
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.
Dimension	Represents the dimension column that is being displayed or analyzed using the widget.
Dimension Value	Represents the specific dimension items within the dimension column used for the visualization in the widget.

Steps to Use MAXX

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

MAXX in Calculated Columns

Parameter	Description
Expression	A placeholder in a function that is replaced with the column names.
Condition	A placeholder in a function that is replaced with the condition filter.
Column Name	The name of the column in the dataset or Datasource that contains the values you want to analyze.
Filter Condition	A filter condition returns the data points that meet the defined condition that you want to analyze. The filter condition can be either a string or a numeric.

Steps to Use MAXX in Calculated Columns

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

Objective Consider that you have the below sales dataset, your goal is to find the maximum entry value under MARKET PRICE for the COUNTRY is Brazil.

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	53.8155	8
2024-01-14	Brazil	Snacks	20.185		4
	Brazil	Cosmetics	40.485	46.1529	2

You can use the MAXX function like

MAXX([QUANTITY] , [CATEGORY]="Cereal")

The new calculated column “Max Market Price” will return the total number of rows in the dataset considering nulls and blanks as 53.8155

ORDER DATE	COUNTRY	CATEGORY	UNIT PRICE	MARKET PRICE	QUANTITY	MIN MARKET PRICE
03-01-2024	Brazil	Baby Food	38.41	43.7874	2	53.8155
07-01-2024	Japan	Spices	45.56	50.8155	20	53.8155
	Japan			43.7874	10	53.8155
18-01-2024				32.3019	4	53.8155
22-01-2024	Brazil	Cosmetics	28.335	23.0109	7	53.8155
26-01-2024	Canada		20.185	23.0109	9	53.8155
04-01-2024	France	Cereal	25.26	28.7964	9	53.8155
09-01-2024	Brazil	Cereal	44.575	53.8155	8	53.8155
14-01-2024	Brazil	Snacks	20.185		4	53.8155
	Brazil	Cosmetics	40.485	46.1529	2	53.8155