April 12, 2016

Tableau Tip Tuesday: How to Use LOD Calcs to Compare Avg Sales to Avg Sales per Customer

For this week’s Tableau Tip Tuesday, I continue the series of Level of Detail Expressions by looking at the difference between average sales and average sales per customer. The idea here is you might want to answer the question:

For each state (or product category or whatever), what is the average sales per customer.

This is a very different question than simply the average sales per state. I walk through a couple of examples that hopefully help clarify the technique.