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 quick-sight , calculations	2	451	July 5, 2023
Date Difference between aggregated and non aggregated field Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	4	85	June 28, 2024
How to compare the last date with other dates in Quick Sight Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	7	610	December 15, 2023
Aggregated and non aggregated Q&A quick-sight , calculations	5	3456	November 15, 2021
Calculated field problem Q&A data-source , analysis , filters , parameters , formatting , error , feature-request , quick-sight , data-preparation , calculations , how-to	6	722	March 20, 2023