Explain the Logical Function ' MIN' in Tableau with Example?

In Tableau, the "MIN" logical function is used to find the minimum value within a specified field or expression. It returns the smallest value among the selected values.

The syntax of the "MIN" function in Tableau is as follows:

MIN(expression)

Here's an example to illustrate how the "MIN" function works in Tableau:

Suppose you have a dataset of products and their corresponding sales quantities. You want to determine the minimum sales quantity among all the products.

MIN([Sales Quantity])

In this example, the "MIN" function is used to find the minimum value in the [Sales Quantity] field. It evaluates all the values in the field and returns the smallest value.

For instance, if the sales quantities of the products are [25, 50, 30, 80, 65], the "MIN" function will return 25, which is the smallest value among the sales quantities.

The "MIN" function is useful in various scenarios in Tableau, such as identifying the lowest value in a dataset, comparing values, or setting up conditional logic based on the minimum value. It allows you to easily determine the minimum value within a specified field or expression, facilitating data analysis and visualizations.