Book Image

Learning Tableau 2022 - Fifth Edition

By : Joshua N. Milligan
Book Image

Learning Tableau 2022 - Fifth Edition

By: Joshua N. Milligan

Overview of this book

Learning Tableau 2022 helps you get started with Tableau and data visualization, but it does more than just cover the basic principles. It helps you understand how to analyze and communicate data visually, and articulate data stories using advanced features. This new edition is updated with Tableau’s latest features, such as dashboard extensions, Explain Data, and integration with CRM Analytics (Einstein Analytics), which will help you harness the full potential of artificial intelligence (AI) and predictive modeling in Tableau. After an exploration of the core principles, this book will teach you how to use table and level of detail calculations to extend and alter default visualizations, build interactive dashboards, and master the art of telling stories with data. You’ll learn about visual statistical analytics and create different types of static and animated visualizations and dashboards for rich user experiences. We then move on to interlinking different data sources with Tableau’s Data Model capabilities, along with maps and geospatial visualization. You will further use Tableau Prep Builder’s ability to efficiently clean and structure data. By the end of this book, you will be proficient in implementing the powerful features of Tableau 2022 to improve the business intelligence insights you can extract from your data.
Table of Contents (20 chapters)
18
Other Books You May Enjoy
19
Index

Level of detail calculations

Before getting into practical examples of using level of detail calculations, let’s take a moment to understand the syntax and types of level of detail calculations.

Level of detail syntax

Level of detail calculations follow this basic pattern of syntax:

{FIXED|INCLUDE|EXCLUDE [Dim 1],[Dim 2] : AGG([Field])}

The definitions of the preceding declaration are as follows:

  • FIXED, INCLUDE, and EXCLUDE are keywords that indicate the type of level of detail calculation. We’ll consider the differences in detail in the following section.
  • Dim 1, Dim 2 (and as many dimensions that are needed) is a comma-separated list of dimension fields that defines the level of detail at which the calculation will be performed.
  • AGG is the aggregate function you wish to perform (such as SUM, AVG, MIN, and MAX). If the field is already an aggregate calculation, you will not specify an additional aggregate function.
  • Field...