Skip to Content

Hi All,

Very often we are expecting Alerters in Webi Charts like in Xcelsius  (Conditional Formatting) .

Yet we don’t have direct call , but it can be possible in Webi 4.0.

Workaround

* I want color coding in a column chart ,

   Green for Amount Greater than 5000000

   Red  for Amount less than 5000000

 

1. Create a variable for Amount Greater than 5000000

=[Amount] Where ([Amount]>5000000)

2.Create a variable for Amount Less than 5000000

Amount] Where ([Amount]<5000000)

3.Turn this table into Column Chart with Dual Value Axis , assign Greater than 5000000 to Axis 1 and Less than 5000000 to Axis 2

4.Right Click , Format Chart , Palette Style , Green for Primary Color and Red for Secondary color,

(Since we don’t have option to select our own colors(Red and Green) in webi like 3.X , we only have option to select the below palettes and change transparency)

Now you got your Chart with alerters , but only drawback is scales .

There could be a misperception that Greater than 5000000  and Less than 5000000 bars will at same height

to avoid this we got our own scale definition like in Xcelsius

5.Create two  variables

Max Amount

=Max([Amount])

Min Amount

=Min([Amount])

Select Value Axis

In Scaling , assign Minimum Value to “Fixed Value” and point Min Amount variable

assign Maximum Value to  “Fixed Value” and point Max Amount variable

Select Value Axis2

In Scaling , assign Minimum Value to “Fixed Value” and point Min Amount variable

assign Maximum Value to  “Fixed Value” and point Max Amount variable

Now , result will be

Hope you’ll get use of this

To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

  1. Thirupathi Reddy Peram

    Hello Sateesh/All,

    Thanks for sharing you knowledge and appreciating you.

    Here is a bug in the chart display, when you take two axises generally there will be two bars (even though one bar not show but its blank space will be present in the chart).

    The perfect solution for this is take stacked column chart with single axis.
    add two variables to value axis-1, that’s it.

    If you want to include you target in the same chart, add target object to value  Axis-1 and go to Format Chart -> Global -> Region type -> change Target Measure region type to Line (see below Image).

    Axis.PNG

    Finally The chart looks like below.
    Cha.PNG

    Thanking You.

    Regards,

    Thiru

    (0) 

Leave a Reply