Book Image

Tableau 10 Bootcamp

By : Joshua N . Milligan, Donabel Santos
Book Image

Tableau 10 Bootcamp

By: Joshua N . Milligan, Donabel Santos

Overview of this book

<p>Tableau is a leading visual analytics software that can uncover insights for better and smarter decision-making. Tableau has an uncanny ability to beautify your data, compared to other BI tools, which makes it an ideal choice for performing fast and easy visual analysis.</p> <p>A military camp style fast-paced learning book that builds your understanding of Tableau 10 in no time. This day based learning guide contains the best elements from two of our published books, Learning Tableau 10 - Second Edition and Tableau 10 Business Intelligence Cookbook, and delivers practical, learning modules in manageable chunks. Each chunk is delivered in a "day", and each "day" is a productive day. Each day builds your competency in Tableau. You will increase your competence in integrating analytics and forecasting to enhance data analysis during the course of this Bootcamp.</p> <p>Each chapter presents core concepts and key takeaways about a topic in Tableau and provides a series of hands-on exercises. In addition to these exercises, at the end of the chapter, you will find self-check quizzes and extra drills to challenge you, to take what you learned to the next level. To summarize, this book will equip you with step-by-step instructions through rigorous tasks, practical callouts, and various real-world examples and assignments to reinforce your understanding of Tableau 10.</p>
Table of Contents (16 chapters)
Title Page
Credits
About the Authors
www.PacktPub.com
Customer Feedback
Preface

Level of detail calculations


Level of detail calculations (sometimes abbreviated as LoDcalcs or LoD expressions) allows you to perform aggregations at a specified level of detail, which may be different from the level of detail defined in the view, and then work with the resulting value at a row level. In this way, you can think of LoD calculations as a hybrid between aggregate calculations and row-level calculations.

Level of detail syntax

Level of detail calculations follow this basic pattern of syntax:

{[TYPE] [Dimension 1],[Dimension 2] : AGG([Measure])} 

The parts of the declaration above are as follows:

  • TYPE: This is the type of LoD calculation (FIXED, INCLUDE, or EXCLUDE); these are described in detail in the following section.
  • Dimension 1: This is a comma-separated list of dimension fields that define the level of detail at which the calculation will be performed. You may use any number of dimensions to define the level of detail.
  • AGG: This is the aggregate function you wish to perform...