Hi guys, I need to create a calculated field that calculates the value for me considering the current month and another calculated field considering the previous month according to the date filtered by the user (filter by parameter). ifelse(dateDiff({my_date},${Param_Date},"MM") = 0, {my_dynamic_c…

Hi Please review this document which might clarify how you can update this function to have matching aggregations in both numerator and denominator. [image] Finding solutions for mismatched aggregation errors in Quick Sight calculations Technical Articles Fin…

Hello @Ramon_Lopez The error changed from “Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination” to “Nesting of aggregate functions like {{aggregateFunction1}} and {{aggregateFunction2}} is not allowed” –before: ifelse(dateDiff({my…

Hi @July , It’s been awhile since last communication on this thread so following up to see if you’re still encountering issues with your calculated field or if you were able to find a work around in the interim. If we do not hear back within the next 3 business days, I’ll close out this topic. Tha…

Hi @July , Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new pos tin the community and link this discussion for relevant information if needed. Thank you!

Incompatible aggregation. How to solve?

Q&A

Ramon_Lopez February 25, 2025, 8:49pm 2

Please review this document which might clarify how you can update this function to have matching aggregations in both numerator and denominator.

Topic		Replies	Views
Mismatched aggregation. Custom aggregations can't contain both aggregated and nonaggregated fields, in any combination error Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	3	4355	April 18, 2024
Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	2	887	May 16, 2024
Quick Sight Calculated Field Error Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	408	January 31, 2024
"Mismatched aggregation - custom aggregations can't contain both aggregated and non-aggregated fields Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	3	201	December 12, 2023
Mismatched aggregation errors Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	321	October 17, 2023

Incompatible aggregation. How to solve?

Related topics