MAX_AGG - Returning the Maximum Value of a Field- FineBI Help Document

Last update：December 26, 2024

Overview

Syntax	MAX_AGG(Array)	According to the current analysis dimension, this function returns the maximum value of the field. The generated results are listed in a data column. The number of rows in the data column is consistent with that in the current analysis dimension.
Parameter	Array	The Array parameter must be the result returned by a non-aggregate function formula, which can be a calculation result of an indicator field, dimension or indicator field and a common formula. When the Array parameter is a non-numeric field, it can be used only in the DEF function.

Notes

The function supports one parameter of any type for real-time data.
The function is only supported on the dashboard and not supported for self-service datasets.

Example

If the horizontal axis is the dimension field Day, the value returned by the calculation field MAX_AGG(Sales Volume) of the vertical axis is the maximum daily sales.

If the horizontal axis is the dimension field Month, the value returned by MAX_AGG (Sales Volume) is the maximum monthly sales.

Calculating the Maximum Time in the Current Dimension

You need to calculate the maximum time in the current dimension, for example, the maximum time in the monthly data in Contract Signing Time, as shown in the following figure.

Click , set Field Name to Maximum Time, and enter FORMAT(TODATE(MAX_AGG(DATETONUMBER(Contract Signing Time))),"YYYY-MM-dd HH:mm:ss"), as shown in the following figure.

The following table describes the formula.

Formula	Description
DATETONUMBER(Contract Signing Time)	Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date.
MAX_AGG(DATETONUMBER(Contract Signing Time))	Returns the maximumnumber of milliseconds in the current dimension. (The returned value is of the numeric type.)
TODATE(MAX_AGG(DATETONUMBER(Contract Signing Time)))	Converts the maximum number of milliseconds in the current dimension to a specified date.
FORMAT(TODATE(MAX_AGG(DATETONUMBER(Contract Signing Time))),"yyyy-MM-dd hh:mm:ss")	Converts the maximum date (the value returned by TODATE(MAX_AGG(DATETONUMBER(Contract Signing Time)))) in the current dimension to the format yyyy-MM-dd hh:mm:ss.

Drag the Contract Signing Time field into the horizontal axis, group the field by Year-Month, and drag Maximum Time into the horizontal axis, as shown in the following figure.

Previous：MIN_AGG - The Minimum Value

Next：MEDIAN_AGG - Median

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

MAX_AGG - Returning the Maximum Value of a Field

Overview

Notes

Example

Calculating the Maximum Time in the Current Dimension

附件列表