Dear all,
I have an issue with coloring a simple bar chart. I am using the following expression for the coloring:
=if(date(PROMISE_DATE, 'DD-MM-YYYY')<date(today(), 'DD-MM-YYYY'), rgb(0,128,0)
,if(date(PROMISE_DATE, 'DD-MM-YYYY')=date(today(), 'DD-MM-YYYY'), rgb(0,0,128)
,if(date(PROMISE_DATE, 'DD-MM-YYYY')>date(today(), 'DD-MM-YYYY'), rgb(0,255,0))))
I tested in a table object and it assigned the colors properly. When I attempt to use the same expression in the bar chart -> under Appearance -> Colors and Legend -> Expression, it just doesn't work.
Any ideas why this might be happening?
Thanks in advance!
BR,
Shelly
