Mismatched aggregation. Custom aggregations can't contain both aggregated and nonaggregated fields, in any combination error

[duncan]

Hello @Ciku !

I found this article very helpful when trying to trouble shoot that error:

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 …

Let me know if this helps!