Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm receiving an invalid expression error when trying to create a flag in my script. I'm not sure what I'm doing wrong. Can anyone help me?
LOAD
%METRIC_KEY,
if(TARGET_VARIANCE = 'U',
if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))<THRESHOLD_TARGET), 'Bad',
if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))>= sum(THRESHOLD_TARGET) and if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))< if(MASK_DISPLAY = '#.##%', num(TARGET, '0.00%'),
TARGET), 'OK', 'Good')),
if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))<TARGET, 'Good',
if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))<= THRESHOLD_TARGET and if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),
Median(MEDIAN))> if(MASK_DISPLAY = '#.##%', num(TARGET, '0.00%'),
TARGET), 'OK', 'Bad'))) as Flag
Resident FACT_temp
Group by %METRIC_KEY;
Thank you in advance.
You need to have
TARGET_VARIANCE,MASK_DISPLAY at group by too, since they are not beeing aggregated at expression