Trellis bar chart colours

danielnevitt — Tue, 27 Jun 2023 19:17:27 GMT

Hi all,

Is it possible to create a trellis bar graph where the bars are different colours based on an expression?

I have the attached graph and I would like to show the bars as green when they are 100% and red when they are below 100%.

I tried the following expression, however it doesn't work:

If(Count({<[Trader Review Status]={`Complete On Time`}>}trade_num)/Count(trade_num)>0.9,green(),If(Count({<[Trader Review Status]={`Complete On Time`}>}trade_num)/Count(trade_num)<0.9,red()))

Thanks,
Daniel

topic Trellis bar chart colours in App Development

Trellis bar chart colours