Thursday, June 22, 2023

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

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

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

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

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

Suppose you have a dataset with a column called "Temperature" that contains the temperature readings for different cities.


To find the minimum temperature from the "Temperature" column using the MIN 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:

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

The calculated field, which utilizes the MIN function, will return the minimum temperature value from the "Temperature" column.

In this example, the MIN function will return the value 6, as it represents the lowest temperature among all the cities.

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

No comments:

Post a Comment

If you have any doubts. Please let me know

How can you create an alias for a table in a SQL query?

In SQL, you can create an alias for a table in a query to give the table a temporary, alternative name that you can use in the query. Table ...