From the course: Tableau Essential Training
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Use level of detail expressions - Tableau Tutorial
From the course: Tableau Essential Training
Use level of detail expressions
- [Instructor] One terrific capability in Tableau is the ability to create level of detail expressions. Most calculations happen at a specific level such as the sheet level, the table row level, and so on. Level of detail expressions let you specify the level at which you want your calculation to occur independently of the arrangement of fields within your viz. And in this movie, I will show you how to define three types of level of detail expressions and give examples of their use. My sample file is 04_05 level of detail and you can find it in the chapter 4 folder of the exercise files collection. In this visualization, I have already created a text table that breaks down product category costs for orders by property state. So let's see what happens if I create level of detail expressions using three keywords, include, exclude, and fixed. I'll start by using include and we'll work at the state level. So I'll create a new calculated field by going to the analysis menu and then about…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.