How to correctly use distinct count and case when in etl (unknown error)

Le1331
Le1331 Member
in Magic ETL
Screenshot (47).png

Could someone help and explain what's causing this error? And how to correct it? Thank you

Tagged:

Answers

  • MichelleH
    MichelleH Coach

    @Le1331 Are you using the Formula Tile or a Group By tile? Aggregate functions like counts and sums must be done in the Group By tile since they depend on the values across multiple rows. The Formula Tile only evaluates functions based on values within the same row.

Categories