I have a calculated field which is an ifelse statement which checks 2 requirements (both are aggregated fields). When these requirements are met, i want to return report_date (date the data is from). However since this date is not aggregated, i get the error mismatched aggregation. Here are my field…

Now what i’ve done is this: [image] which is similar to what you provided (getting the max report_date) [image]

How to aggregate a date field to use in a calculated field to return

HarveyB-B August 12, 2024, 8:51am 4

Now what i’ve done is this:

which is similar to what you provided (getting the max report_date)

Topic		Replies	Views
Calculated field aggregated and non aggregated Q&A calculations	2	460	July 5, 2023
Date Difference between aggregated and non aggregated field Q&A date , calculations , Business-Intelligence-Engineer	4	100	June 28, 2024
How to compare the last date with other dates in Quick Sight Q&A error , calculations , Business-Intelligence-Engineer	7	652	December 15, 2023
Incompatible aggregation. How to solve? Q&A formulas , parameters , error , calculations , Business-Intelligence-Engineer	5	64	March 21, 2025
Mismatched aggregation errors in Quick Sight calculations Q&A calculations , Business-Intelligence-Engineer	2	32	February 19, 2025