I feel really dumb asking this, but I don't know how to fix it. I've read through many posts and watched several videos for dynamic bookmarks and I'm still lost. I think I need a dummies version.
SUMMARY: How can I make this dynamic field, dynamic in the book mark?
Background: I inherited script for a field based on an inline load. The field I am concerned with is called Measure:
PERFORMANCE_MEASURES_TEMP:
load * inline [
MeasureID,Measure
1,'BASE LINE'
2,'TOP LINE'
3,'PLAN GOAL'
4,'BEST CASE SCENARIO PLAN'
5,'CURRENT YEAR SALES'
6,'PRIOR YEAR SALES'
7,'2 YEAR AGO SALES'
];
PERFORMANCE_MEASURES_TEMP2:
LOAD *,
YEAR(TODAY()) AS CURRENT_YEAR,
YEAR(ADDYEARS(TODAY(),-1)) AS PRIOR_YEAR,
YEAR(ADDYEARS(TODAY(),-2)) AS [2 YEARS AGO]
RESIDENT PERFORMANCE_MEASURES_TEMP;
DROP TABLE PERFORMANCE_MEASURES_TEMP;
PERFORMANCE_MEASUES:
LOAD
MeasureID,
IF(MeasureID=5, Measure&' ('&CURRENT_YEAR&')',
IF(MeasureID=6, Measure&' ('&PRIOR_YEAR&')',
IF(MeasureID=7, Measure&' ('&[2 YEARS AGO]&')',Measure))) AS Measure
RESIDENT PERFORMANCE_MEASURES_TEMP2;
DROP TABLE PERFORMANCE_MEASURES_TEMP2;
Last year output:
Measure={'CURRENT YEAR SALES (2020)','PRIOR YEAR SALES (2019)','2 YEAR AGO SALES (2018)'}
This year output:
''
Expected output:
Measure={'CURRENT YEAR SALES (2021)','PRIOR YEAR SALES (2020)','2 YEAR AGO SALES (2019)'}
