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]

Hello @HarveyB-B ! Can you share the calculated field that threw the error? You could try something similar to the following: ifelse( {EnteredArrearsFlag} = 1, max({Date}, [{EnteredArrearsFlag}]), NULL )

Hello, i was trying to do the EnteredArrearsFlag but return the report_date the date it matched the requirements, so would look like this: ifelse( {case_arrears_aggre} > 0 AND PreviousDayArrears <= 0, report_date, NULL ) but since the PreviousDaysArrears is a calculated field, i don’t think i …

I now have another thing i want to add, but not sure if its worth making a new post for. I’ve mocked up what i want it to look like [image] Basically, while IsArrears = 1, i want to return the max(EnteredArrearsDate). So it should return what i’ve mocked up quickly. Using this, i will be able to…

Hello @HarveyB-B ! I’m glad the first part of this worked out. For the second part, is {IsArrears} aggregated or a calculated field?

Hi there. Sorry i forgot to mention that flag. No, its an ifelse statement which is based on whether or not case_arrears is > 0. [image]

Hey @HarveyB-B ! Does using the same solution above not work for this as well? [image] How to aggregate a date field to use in a calculated field to return Question & Answer Now what i’ve done is this: [image] which is similar to what you provided (getting the max repor…

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

Q&A

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	466	July 5, 2023
Date Difference between aggregated and non aggregated field Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	3	107	June 28, 2024
How to compare the last date with other dates in Quick Sight Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	6	709	December 12, 2023
Incompatible aggregation. How to solve? Q&A formulas , parameters , error , quick-sight , calculations , Business-Intelligence-Engineer	4	91	March 21, 2025
Mismatched aggregation errors in Quick Sight calculations Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	44	February 19, 2025

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

Related topics