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? 



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.


Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!