I am trying to automatically upload in the script the color that must be used in charts for certain dimensions. Specifically, I am upload a table
LOAD
Revenue_Code,
Revenue_Type,
RGB_Color
FROM ...
Revenue_Code
Revenue_Type
RGB_Color
A
Tires
RGB(255,255,255)
B
Gear
RGB(255,255,255)
I have linked this table 'Revenue Code' with the table with all the data.
Once completed the upload, I tried to assign in chart properties -> expression -> background color the RGB_Color dimension but this isn't the correct way I guess.
