Bar Chart, Conditional Color

Ignition
1

This is probably a stupid question, but is it possible in a bar chart to have the color of each individual entry change based on its value?

For example anything over 85 is green and anything under 85 is red?

Thanks in adavance.

2

Okay I did this a strange way. It works though.

FWIW I made two data sets

SELECT Hour,
IF(Efficiency < 85,Efficiency,0)
AS Actual
FROM shopfloormonitordata WHERE Machine = ‘T5’

SELECT Hour,
IF(Efficiency >= 85,Efficiency,0)
AS Actual
FROM shopfloormonitordata WHERE Machine = ‘T5’

Thanks!

3

Not bad! :thumb_left:

It should be possible to do it in one dataset:

SELECT Hour,
IF(Efficiency < 85,Efficiency,0) AS Actual1
IF(Efficiency >= 85,Efficiency,0) AS Actual2
FROM shopfloormonitordata WHERE Machine = 'T5'

Not tested, but it should work.