Group By value with Average aggregation calculating differently

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!

Best Answer

  • Tomo
    Tomo 🟢
    Accepted Answer

    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.

Answers