Group By value with Average aggregation calculating differently

bahrittknee
bahrittknee
in Data Platform & Data Science

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!

Tagged:

Best Answer

  • Tomo
    Tomo

    domo

    💎
    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

Categories