Group By value with Average aggregation calculating differently

bahrittknee

Hi there, 

 

I believe I'm missing what is going on with my various attempts to Group By source data in order to gain an Average aggregate of a score. I take the entire dataset and when I place it in a table card and AVG the score, the calculation is correct but anytime I use the Magic ETL I was presented with a different value and yet a third value when attempting SQL.

 

What am I missing? 

 

Thanks!

Screen Shot 2018-03-27 at 4.33.11 PM.png

Screen Shot 2018-03-27 at 4.33.24 PM.png

Screen Shot 2018-03-27 at 4.32.28 PM.png

Screen Shot 2018-03-27 at 4.32.11 PM.png

Tomo

Hi @bahrittknee

 

Not all rows are used in DataFlow preview. Is not it the cause?
In ETL, I think that only 100 rows are used.