I have data in years and quarters.
After 2015, some archiving needs to take place but before 2015, I don't need to touch anything
For archive workings, I need to only reference workings from Year = 2014 Quarter = Q3.
I know my set analysis is all over the place in the Archived workings.
//if Year is greater than 2015, workings + archived workings
if(Year > 2015,
//Workings for all countries
(1 - Count({<isPolicy={1}, CheckNo={7}, Validity.Status={N,I,R}, isApplicableToDataValidationComplianceCheck={'Y'}>} distinct Validity.Value)
/sum({<Accuracy.Status={N,I,R}>}[TIA policy count]))
+
// + Archived workings
sum ({< (1 - count({<isPolicy={1}, CheckNo={7}, Archived.Status={N,I,R}, Archived.isApplicableToDataValidationComplianceCheck={'Y'}>} DISTINCT Archived.Value) /sum({<Accuracy.Status={N,I,R}>}[TIA policy count])) } Year= {'2014'} Quarter = {'Q3'}),
//else, just do calculations as normal.
1 - Count({<isPolicy={1}, CheckNo={7}, Validity.Status={N,I,R}, isApplicableToDataValidationComplianceCheck={'Y'}>} distinct Validity.Value)
/sum({<Accuracy.Status={N,I,R}>}[TIA policy count]))
Question 1: Help with my Archive Set Analysis?
Question 2: Would it be better to put this set analysis in my loader, rather than as an expression as I would say this would be mighty tough to calculate for each Quarter and slow down the app.
