Issue coloring a bar chart

ShellyG — Sat, 16 Nov 2024 17:28:53 GMT

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

topic Issue coloring a bar chart in App Development

Issue coloring a bar chart