Book Image

Creating Data Stories with Tableau Public

Book Image

Creating Data Stories with Tableau Public

Overview of this book

Table of Contents (18 chapters)
Creating Data Stories with Tableau Public
Credits
About the Author
Acknowledgments
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

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...