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

 In Tableau, the MIN function is an aggregate function used to calculate the minimum value of a numeric field within a specified context or group. It allows you to find the lowest value in a given set of data.

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

MIN(expression)

where the expression is the field or calculation for which you want to find the minimum value.

Here's an example to demonstrate how to use the MIN function in Tableau:

Suppose you have a dataset that contains information about the sales of different products in different regions. You want to determine the lowest sales value across all regions.

1. Open Tableau and connect to your dataset.
2. Drag the "Region" field to the Rows shelf.
3. Drag the "Sales" field to the Columns shelf.
4. In the Marks card, change the aggregation of the "Sales" field to "Min" by clicking on the drop-down arrow next to the field and selecting "Min." This applies the MIN function to the "Sales" field and calculates the minimum sales value for each region.
5. Tableau will display the minimum sales value for each region in the view.

The result will show you the lowest sales value across all regions. This allows you to identify the region with the lowest sales performance.

The MIN function can also be used with other aggregate functions or in combination with other calculations to perform more complex analyses. For example, you can use the MIN function in combination with the IF function to find the minimum value that meets certain conditions.

In summary, the MIN function in Tableau helps you identify the minimum value within a dataset, providing valuable insights into your data.