How to Use LOD Calcs to Compare Avg Sales to Avg Sales per Customer

#TableauTipTuesday: How to Use LOD Calcs to Compare Avg Sales to Avg Sales per Customer

[@mohitpandey5190]

Simple but best explanation on LOD.

[@alexnapier111]

Excellent video, in fact all you video's are excellent!

[@yishaktaye1951]

Very Helpful..

[@ruiqimao1078]

Hi Andy, from my understanding, your LOD: AVG({INCLUDE [Customer Name]: SUM([Sales])}), is the same as SUM([Sales])/COUNTD([Customer Name]); Is that correct? If so, which expression is faster in tableau calculation? Thanks!

[@ahmedel-naggar527]

Actually the " LOD: AVG({INCLUDE [Customer Name]: SUM([Sales])}) " doesn't get the average when I tested it , it give the same result as the sum(sales)

[@ruiqimao1078]

did you calculate it within the 'table' set up (since it is 'Include' LOD calculation, you need the table to be the first agg level)? I got the same result using LOD: AVG({INCLUDE [Customer Name]: SUM([Sales])}) as SUM([Sales])/COUNTD([Customer Name])