Tableau Calculations - Everything You Need to Know
This workshop delves into Tableau calculations, emphasizing the importance of understanding levels of detail for choosing the right calculation type.
It covers aggregate and non-aggregate calculations and explores the use of Level of Detail Expressions (LODs) for precise calculations at different granularities.
You learn how to properly configure table calculations and use LODs most effectively.
Additionally, it discusses the impact of context filters, dimensions, and order of operations on calculations.
Download the data here - https://bit.ly/NLT-Calculations
Time stamps:
0:00 Introduction & What is Level of Detail?
2:57 How dimensions define granularity in Tableau
8:07 Aggregate vs non-aggregate calculations explained
10:52 Example: MLB baseball batting data
22:45 Finding the lowest level of granularity (Superstore)
35:32 Non-aggregate calculations explained
44:52 Example: Extra base hits calculation
45:21 Example: Strikeout ratio (non-aggregate)
52:06 The aggregate vs non-aggregate ratio problem
1:00:02 Example: High strikeout ratio with IF/THEN
1:08:06 Table calculations introduction
1:11:02 Percent of total table calculation
1:16:03 Using Specific Dimensions to lock table calcs
1:21:00 Exercise: Build your own percent of total
1:27:28 Rule of thumb: When to use table calcs vs LODs
1:31:45 Level of Detail Expressions (LODs) introduction
1:34:30 Fixed LOD syntax explained
1:37:40 Fixed LOD example
1:43:05 Exclude LOD example (and why it's tricky)
1:45:34 Nested LODs
1:51:04 Table calc alternative to LODs
1:54:55 Wrap up & Q&A
1:59:55 Context filters impact on LODs
----------
To go deeper, check out my courses:
→ Tableau Starter Kit - A beginner-friendly course designed to help you understand Tableau quickly - https://www.nextleveltableau.com/star...
→ Tableau Core Concepts - A comprehensive, self-paced course for Tableau users ready to level up - https://www.nextleveltableau.com/tcc
→ Join Next-Level Tableau - My most comprehensive Tableau program to help analysts become industry leaders, with the support of a like-minded community, and 1-to-1 help from me - https://www.nextleveltableau.com/
📩 The Dual Axis Newletter
Each week, I'll send you Tableau tips, tutorials, and strategies to design better dashboards, have more impactful, and stand out in your career: https://nlt.kit.com/
🔽 Connect With Me
• Official website - https://www.nextleveltableau.com/
• LinkedIn - / andykriebel
#tableau #dashboard #tutorial #beginner