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

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

Answers

  • @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.