This content has been marked as final.
Show 1 reply

1. Re: Aggregating data into Bins at a data indenture level not in the display
Yuriy Fal Jun 27, 2016 4:02 AM (in response to Jeff Ard)1 of 1 people found this helpfulHi Jeff,
Definitely you're better with LevelOfDetail (LOD) calculations.
Something like this:
// [Net Value per Order Number]
{ FIXED [Order Number] : SUM( [Net Value] ) }
// [Net Value per Order Number Custom Bins]
// 1000 could be a Parameter aka Bin Size
INT( [Net Value per Order Number] / 1000 ) * 1000
// Average Order Value  variant 1
AVG( [Net Value per Order Number] )
// Average Order Value  variant 2
SUM( [Net Value per Order Number] ) / COUNTD( [Order Number] )
Hope it could help.
Yours,
Yuri