Skip to main content

I’ve looked at the articles about this process, but still not getting the results I am looking for.  

 

I have a Bar Chart that looks like this:

The values are based on a Attribute filed on the Stock Items.  Values are Medium, Low and High.

In the Color option of the Series, I have the following formula based on the documentation.

=Switch(Value = 'High', '#AB400C', Value = 'Medium', '#e9e00', Value = 'Low', '#a9d360')

But the results are this:

Any ideas?

I’m guessing that you’re using the description of the Attribute and not the value. Is it a combo?

 

If it is, then you should tru to use the Value. Hope this works.


When you say use the Value, and my attribute is set up like the following:

 

ValueId = 1, Description  = Low

 

I should change my Switch statement to be:

=Switch(Value = '1', '#AB400C', Value = ‘2', '#e9e00', Value = '3', '#a9d360')

 

That did not work either.


And my Attributes are set as Combo


After stepping away for a couple of days, I figured out I needed to use “Display Value” as that was how my GI was built to reference the attribute.

 

Thanks for the help.  Once I allowed my mind to clear, it made sense.


Reply