Webi Chart Custom Range Coloring Greater than 100 Max

[Former Member]

HI Webi gurus!

I am trying to create a heat map and display blocks with conditional formatting of red, yellow and green and so I am using the  format chart  and palette's properties to use 'internal palette' and set range values for three colors.  Version is 4.1 Sp04.

The problem is that we want to display the blocks green if 100% or greater, but the color zones do not allow for Max value to exceed 100.

So the heat map displays blocks greater than 100 as grey instead of green.

Any ideas? 

Thanks!

Lee Lewis

[sateesh_kumar1]

Hi Lee ,

Webi engine by default calculates measure to 100% only.

Calculate variable : condition which gives you percent greater than 100.

As Example :

V_Avg Lease % =[Lease]/Average([Lease]) In Block*100 .

Turn it to Heat map .In Assign Data ,

There is an option shapes with values out of range.Specify green color over here.