Hey All,

Need some help on a bar chart in 11.1.5.  We have a bar chart that if a percent is above 95% color the bar green, anything below 95% would be colored Red.

In order to get the color green or red, I created a calculation that evaluates to 1 (above or = 95%) or 0 (below 95%).  All good and I can use this to set the color and use a color palette.

However, if the bars for the week are all below 95% then they turn green because it's the first color.  What I'm finding is for a particular week if it's either all above 95% or all below 95% it just grabs the first color.

I would like to make sure that every single time that it colors correctly.  Searching, I found that I could set colors for certain values and thought would be the way to go, but I can't find the option in 11.1.5 visualizations.

Can anyone provide me some assistance on this, it has to be done!

Thanks,
Jeff

------------------------------
Jeff Jones
------------------------------

#CognosAnalyticswithWatson

Hi Jeff,

Try to look in the accelerator catalog, i´ve made a google chart that supports that.

Br
René

------------------------------
René Kent Nielsen
Brand manager
CogniTech A/S
Herning
------------------------------

Original Message:
Sent: Wed September 09, 2020 12:48 PM
From: Jeff Jones
Subject: Bar Chart Colors

Hey All,

Need some help on a bar chart in 11.1.5.  We have a bar chart that if a percent is above 95% color the bar green, anything below 95% would be colored Red.

In order to get the color green or red, I created a calculation that evaluates to 1 (above or = 95%) or 0 (below 95%).  All good and I can use this to set the color and use a color palette.

However, if the bars for the week are all below 95% then they turn green because it's the first color.  What I'm finding is for a particular week if it's either all above 95% or all below 95% it just grabs the first color.

I would like to make sure that every single time that it colors correctly.  Searching, I found that I could set colors for certain values and thought would be the way to go, but I can't find the option in 11.1.5 visualizations.

Can anyone provide me some assistance on this, it has to be done!

Thanks,
Jeff

------------------------------
Jeff Jones
------------------------------

#CognosAnalyticswithWatson

Awesome, I will take a look, thanks Rene!

------------------------------
Jeff Jones
------------------------------

Original Message:
Sent: Thu September 10, 2020 03:09 AM
From: René Kent Nielsen
Subject: Bar Chart Colors

Hi Jeff,

Try to look in the accelerator catalog, i´ve made a google chart that supports that.

Br
René

------------------------------
René Kent Nielsen
Brand manager
CogniTech A/S
Herning

Original Message:
Sent: Wed September 09, 2020 12:48 PM
From: Jeff Jones
Subject: Bar Chart Colors

Hey All,

Need some help on a bar chart in 11.1.5.  We have a bar chart that if a percent is above 95% color the bar green, anything below 95% would be colored Red.

In order to get the color green or red, I created a calculation that evaluates to 1 (above or = 95%) or 0 (below 95%).  All good and I can use this to set the color and use a color palette.

However, if the bars for the week are all below 95% then they turn green because it's the first color.  What I'm finding is for a particular week if it's either all above 95% or all below 95% it just grabs the first color.

I would like to make sure that every single time that it colors correctly.  Searching, I found that I could set colors for certain values and thought would be the way to go, but I can't find the option in 11.1.5 visualizations.

Can anyone provide me some assistance on this, it has to be done!

Thanks,
Jeff

------------------------------
Jeff Jones
------------------------------

#CognosAnalyticswithWatson