#### Overview of this book

The Tableau Certified Data Analyst certification validates the essential skills needed to explore, analyze, and present data, propelling your career in data analytics. Whether you're a seasoned Tableau user or just starting out, this comprehensive resource is your roadmap to mastering Tableau and achieving certification success. The book begins by exploring the fundamentals of data analysis, from connecting to various data sources to transforming and cleaning data for meaningful insights. With practical exercises and realistic mock exams, you'll gain hands-on experience that reinforces your understanding of Tableau concepts and prepares you for the challenges of the certification exam. As you progress, expert guidance and clear explanations make it easy to navigate complex topics as each chapter builds upon the last, providing a seamless learning experience—from creating impactful visualizations to managing content on Tableau Cloud. Written by a team of experts, this Tableau book not only helps you pass the certification exam but also equips you with the skills and confidence needed to excel in your career. It is an indispensable resource for unlocking the full potential of Tableau.
Chapter 2: Transforming Data
Chapter 3: Calculations
Chapter 4: Grouping and Filtering
Chapter 5: Charts
Chapter 6: Dashboards
Chapter 7: Formatting
Chapter 8: Publishing and Managing Content
Chapter 9: Accessing the Online Practice Resources
Other Books You May Enjoy

# Moving Calculations

A moving calculation runs by creating an aggregate across a table based on how a user configures the table calculation. This aggregation can be a sum, average, minimum, or maximum.

This kind of calculation is used to smooth the data, meaning that instead of seeing the finer points within the data, the plot line is smoothed into a progressive line to show a trend over time. The following shows an example of using a running average.

Figure 3.28: Table calculation of moving sum

Now you can zoom in on the table calculation, as shown in Figure 3.29, to see how this is calculated.

Figure 3.29: Table Calculation pane

The way this has been calculated is by summing the previous two values, including the current value, as that option has been checked in the configuration pane. You can update the values as you wish by editing the table calculation.

## Percent of Total

One popular use of table calculations is...