In Tableau, what causes a ‘Cannot mix aggregate and non-aggregate arguments’ error in a calculated field?
TableauHard
Tableau — Hard
In Tableau, what causes a ‘Cannot mix aggregate and non-aggregate arguments’ error in a calculated field?
Explanation
The 'Cannot mix aggregate and non-aggregate arguments' error occurs when a calculated field combines aggregated values, like SUM([Sales]), with non-aggregated field references, such as [Sales]. This mismatch causes the error. Incorrect options, like using different data sources or referencing parameters, do not directly relate to this specific error. The correct answer is the only one that addresses the aggregate and non-aggregate mix.
