Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Trellis bar chart colours

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

Labels (1)
0 Replies