From the course: Tableau: Mastering Calculations

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Solution: LOD

Solution: LOD - Tableau Tutorial

From the course: Tableau: Mastering Calculations

Start my 1-month free trial Buy for my team

Solution: LOD

“

Welcome back. How was that for you? I will admit that level of detail calculations sometimes make my brain hurt, but I'm sure you did brilliantly. LODs are great for all these pressing business questions that require nested aggregations outside of what we are actually visualizing. They may take a while to wrap your head around, but once you do, level of detail calculations, hold deep, deep analytical and business value. Let me show you how I solved this function. I decided to use an INCLUDE function. I already have SKU in the view, so I simply need to dip down to the customer level by including the customer ID. Then we can take the distinct count of order ID to determine how many orders from a customer contain that SKU. And of course, close with a curly bracket. Let's call this one Orders per Customer and in parentheses include. We confirm and close with "OK". Drag the new measure into the view and change the aggregation to the average. Once we scroll down, we can see that our wind…

Contents