Percent of Total Calculation Breaking "Other" Grouping Functionality

[Brett]

Hi @erweinstein,

Check out the attached article below, it dives a lot deeper into scenarios that are common to yours. Let me know if this helps with your case:

Finding solutions for mismatched aggregation errors in Quick Sight calculations

Finding solutions for mismatched aggregation errors in Quick Sight calculations Mismatched aggregation errors are common Quick Sight 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 Quick Sight, it’s not always apparent what causes this error. It is important to understand what is aggregated vs non-aggregated from a Quick Sight perspective. This article explores common cases where th…