Mismatched aggregation. Custom aggregations can't contain both aggregated and nonaggregated field

[Giridhar.Prabhu]

Hi @Made_Enny

There is a nice article that explains this problem. I suggest you give it a read to understand your error better and the solution for the same.

Finding solutions for mismatched aggregation errors in QuickSight calculations

Finding solutions for mismatched aggregation errors in QuickSight calculations Mismatched aggregation errors are common QuickSight calculation errors reported by users. This error occurs when the calculated field contains both aggregated and non-aggregated (row-level) values. For users new to QuickSight, it’s not always apparent what causes this error. It is important to understand what is aggregated vs non-aggregated from a QuickSight perspective. This article explores common cases where these …

Regards,
Giri