Hi QuickSight Team, As a QuickSight user all of us are facing this two error like (“Cannot Mix Aggregate and Non Aggregate function" & “Nesting of Aggregate function”) in our day to day work. So can you create one articles on this topic like how to handle when we have facing this type of error the…

I think the “Cannot mix aggregate and non aggregate function” error usually happens when users don’t realize that their visual is at a grain which is different from what’s in the dataset. Here I have a dataset where each row represent a line item in an order placed by a customer. For example, there…

How to handle QuickSight Error: “Cannot Mix Aggregate and Non Aggregate function" & "Nesting of Aggregate function"

Question & Answer

David_Wong September 12, 2023, 10:17pm 7

@Biswajit_1993
I just posted an article on level-aware calculations. It includes a section on mismatched aggregation errors.