The aggregate functions
Aggregation functions in Tableau Public are performed typically on numeric fields. In this section, we will show you how to use the default aggregations on visualizations as well as how to use them in calculated fields.
The following are the aggregate functions that are available for you to apply on a field are also available in the calculated field dialog box. Tableau Public has arranged them in order from the greatest to the least commonly used functions for the visualization as follows:
SUM: This adds up the values within a partition
Average: This sums the measure and divides it by the number of dimension members in the partition
Median: This provides the measure value that's halfway between the greatest and least values
COUNT and COUNTD: These count the number of dimension members and the number of distinct dimension members respectively; they are typically performed on dimensions rather than measures
Minimum and Maximum: These take the least and greatest values...
