assign a value

[RimDataAnalyst]

Good morning ,
I have this graph of tagets vs invoices.
The target of 2028 being not specified I want to assign it the target of the year.
Can somebody help me please ?

[steeefan]

Please elaborate on what you mean by "I want to assign it the target of the year.".

[RimDataAnalyst]

to prevent the target line from falling in 2028 because the value is not provided. I want to assign the value of 2027 to the target of 2028. I hope that it's clearer

[steeefan]

I would suggest creating that in the script because then you will have that data available in any chart of your application.

How to do that however depends on your data model. If you have a simple table where targets are stored, then one solution might be:

CONCATENATE (Target) LOAD
  2028 AS Year,
  Value
RESIDENT
  Target
WHERE
  Year = 2027;