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

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

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

MAX(expression)

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

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

MAX([Sales Quantity])

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

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

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