Explain the Table calculation Function in Tableau?

  Here is an explanation of various Table Calculation functions in Tableau along with examples:

SUM:

Calculates the sum of a field or expression within the specified scope.

Example: SUM([Sales]) calculates the sum of sales for each data point.

AVG:

Computes the average of a field or expression within the specified scope.

Example: AVG([Profit]) calculates the average profit for each data point.

MIN:

Finds the minimum value of a field or expression within the specified scope.

Example: MIN([Temperature]) finds the minimum temperature for each data point.

MAX:

Determines the maximum value of a field or expression within the specified scope.

Example: MAX([Revenue]) finds the maximum revenue for each data point.

COUNT:

Counts the number of non-null values of a field or expression within the specified scope.

Example: COUNT([Orders]) counts the number of orders for each data point.

RUNNING_SUM:

Calculates the running total of a field or expression across the specified scope.

Example: RUNNING_SUM([Sales]) calculates the cumulative sales for each data point.

DIFF:

Computes the difference between consecutive values of a field or expression.

Example: DIFF([Population]) calculates the difference in population between consecutive years.

RANK:

Assigns a rank to each value within a specified dimension or measure.

Example: RANK([Profit]) assigns a rank to each data point based on the profit.

PERCENTILE:

Calculates the value at a specific percentile of a field or expression within the specified scope.

Example: PERCENTILE([Income], 0.75) calculates the 75th percentile income for each data point.

FIRST and LAST:

Returns the first or last value of a field or expression within the specified scope.

Example: FIRST([Date]) returns the first date for each data point.

These are some of the commonly used Table Calculation functions in Tableau. Each function performs a specific calculation on the data, providing valuable insights and allowing for dynamic analysis within your visualizations. By applying these functions appropriately, you can gain a deeper understanding of your data and uncover meaningful patterns and trends.

Thanks for Reading, Subscribe us for more latest Visualization From scratch.