Graph wit a traffic light patern

Is it possible to have a sort of traffic light format.

Like for the health of inventory.
Say below 3 months life shelf red, 4-12 orange and above 12 green.

Are these options there in BO?


rpinxt (BOB member since 2019-01-23)

Depending what version you are on, you’d look at alerters or conditional formats.


Mark P :uk: (BOB member since 2003-02-03)

BO 4.2 SP 7.

But conditional format will make my bar graph red yellow or green?


rpinxt (BOB member since 2019-01-23)

Do you want all bars the same colour, or do you want them different colours depending upon their value?


Mark P :uk: (BOB member since 2003-02-03)

Different colours for the columns.

So the columns that have only a few Use Before Date months red, the columns for 12+ UBD months green and those in between orange.


rpinxt (BOB member since 2019-01-23)

OK.

Create 3 measure variables, one each for your good, medium and bad values in the format:
=If([Measure] meets criteria;[Measure])
This will leave it as null if the measure doesn’t meet the criteria.

Add all measures to your chart as a stacked bar and set a colour for each one accordingly.

Done. :+1:


Mark P :uk: (BOB member since 2003-02-03)

Ahh I see what you mean.
Have a column chart and not stacked.

But your explanation set me in the right direction and I have it now :slight_smile:
Thanks Mark! :+1:


rpinxt (BOB member since 2019-01-23)