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 level of detail calculations


The level of detail calculations (LOD) enable you to tell Tableau Public at exactly which dimensional level you would like to aggregate without having to place that dimension on the visualization. Additionally, you can include or exclude dimensions in the calculations and create calculations that include all the underlying data.

The following are the three types of LOD calculations:

  • FIXED: This computes a value for the dimension that you specify

  • INCLUDE: This computes at a dimensional level and is not included in the visualization itself

  • EXCLUDE: This excludes a dimension that is a part of the visualization

LOD has a big caveat. While you can perform table calculations on them and create aggregations and functions within them, you cannot include table calculations in them.

A FIXED LOD calculation

Each LOD calculation has the following three features that are different from those that we have discussed before:

  • The LOD expression type: In this case, the LOD expression...