Function Description
| Category | Description |
|---|---|
| Syntax | MIN(number) |
| Function | Returns the minimum number value for the current analysis dimension. |
| Parameter | number: the numeric values to compare |
| Number of Parameters | 1 |
| Parameter Type | Number |
| Return Value Type | Number |
| Notes | Aggregate functions can be used only when you add a metric to a chart. They cannot be used in analysis tables. |
Example
When the date field in Row Dimension is set to day granularity, the metric MIN([Sales Amount]) returns the smallest sales amount for each day.
When the date field in Row Dimension is set to month granularity, the metric MIN([Sales Amount]) returns the smallest sales amount for each month.
For example, calculate the minimum contract amount for each month based on Contract Signing Time.
Add a metric named Minimum Contract Amount, and enter the formula MIN([Contract Amount]).
Drag Contract Signing Time to Row Dimension, set it to year-month granularity, and then drag Minimum Contract Amount to the Metric area.
