Chapter 4
Aggregate Functions, Calculated Fields, and Parameters

In previous chapters, you have seen how easy it is to connect to your data from various data sources and to analyze it visually with just a few mouse clicks. With this knowledge, you are already prepared for 80% of the day‐to‐day use cases of Tableau.

There are, however, also those 20% of use cases that involve more complex questions and that may require the use of some more‐advanced techniques, including changing the type of aggregation, creating new calculated fields, or setting up parameters.

Parameters allow you to define values external to your dataset that might have an effect on your visualization. Examples include the factors that might go into the calculation of a “what‐if” scenario or search strings used to filter a text variable.

By the end of this chapter, you will be able to

• Understand when to use which type of aggregation
• Create and edit calculated fields
• Add interactivity...