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

 In Tableau, the MAX function is a number function that returns the maximum value from a given set of numbers or expressions. It is used to find the largest value within a specified range.

The syntax for the MAX function in Tableau is as follows:

MAX(expression)

• expression represents the numeric values or expressions from which you want to find the maximum value.

Here's an example to illustrate the usage of the MAX function in Tableau:

Suppose you have a dataset with a column called "Sales" that contains the sales figures for different products.

Product	Sales
A	100
B	80
C	120
D	90

To find the maximum sales value from the "Sales" column using the MAX function, you can create a calculated field in Tableau:

1. Right-click on a blank area in the "Data" pane in Tableau.
2. Select "Create Calculated Field."
3. In the formula editor, enter the following expression:

MAX([Sales])

4. Click "OK" to create the calculated field.

The calculated field, which utilizes the MAX function, will return the maximum sales value from the "Sales" column.

In this example, the MAX function will return the value 120, as it represents the highest sales figure among all the products.

The MAX function is commonly used in data analysis to identify the highest value within a dataset. It can be applied to various scenarios, such as finding the maximum sales, maximum temperature, maximum profit, or any other numeric metric where you want to determine the highest value. By utilizing the MAX function in Tableau, you can easily extract this information and incorporate it into your visualizations or calculations.