Introducing LODs
Tableau’s default is to show measures in a view based on the dimensions also present in the view. If you have a dashboard with Sales
data and dimensions like State
and City
, and you drag the State
and Sales
data onto the view, the Sales
data will be divided by State
, showing you Sales
per State
. If you want to divide the Sales
data further into smaller chunks, you might add the City
field, resulting in Sales
data per City
, per State
. LODs can manipulate this default behavior.
After completing this chapter, you will be able to divide or partition measures by dimensions that are not in the view and show measures using fewer dimensions than are visible in the view.
To do this, we will build and use two playgrounds. Delivering reports as required by one’s job duties may lead to a thorough knowledge of a limited set of capabilities; that is, a deep but narrow understanding. It can be difficult to set aside time (and justify that time) to explore...