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()))
