Which Alteryx function is used to find the maximum value in a field?

The Max() function is specifically designed to identify and return the maximum value within a specified field in Alteryx. When you're dealing with a dataset and you need to find the highest number, using the Max() function allows you to extract that value efficiently.

It operates by evaluating all the entries within the designated field and determining which one is the greatest. This is particularly useful in data analysis tasks where understanding the extremes of your data can provide insight into trends, outliers, or comparative figures.

In contrast, other functions listed serve different purposes. For example, the Min() function locates the minimum value, the Avg() function calculates the average of the values, and the Sum() function adds all the values together. While these functions are valuable for their respective analyses, they do not assist in finding the maximum value. Thus, the Max() function is the appropriate choice for this task.