Amazon QuickSight – min

The ‘min()’ function in Amazon QuickSight is used to compute the minimum value of a measure within a given level or group.

Syntax

#Start#
min(measure, [group-by level])
#End#

This function takes one argument:

• measure: This parameter specifies the measure for which the minimum value is to be computed.

• group-by level: This parameter is optional and specifies the level or group for which the minimum value is to be computed. If it is not provided, the minimum value of the measure will be computed across all data.

Suppose we have a dataset that contains information about sales for different products and we want to find the minimum sales value across all products. We can use the min() function in Amazon QuickSight to do this.

To find the minimum sales value across all products, we can create a new visual in Amazon QuickSight and add a table with the following settings:

Drag the “Sales” measure to the Values section.

Click on the drop-down arrow next to “Sales” and select “Min”.

This will result in a table that shows the minimum sales value across all products.

Alternatively, we can create a calculated field in Amazon QuickSight with the following expression:

Example

#Start#
min(Sales)
#End#

This expression will compute the minimum sales value across all products.

For instance, if our sales data is as follows:

Then, the minimum sales value across all products will be:

Example

#Start#
min(Sales) = 70
#End#

In this example, we can see that the min() function has computed the minimum sales value across all products, resulting in a useful metric that can inform our business decisions.