Skip to Content
Author's profile photo Sateesh Kumar Bukkisham

Alerters in Webi 4.0 Charts

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

Assigned tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing...:)

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      You are welcome

      Author's profile photo Former Member
      Former Member

      Great Attempt.. Thanks for Sharing . 🙂

      Author's profile photo Former Member
      Former Member

      Nice blog.. thanks for the workaround..

      Author's profile photo sampath guntha
      sampath guntha

      Nice presentaioon

      Author's profile photo Former Member
      Former Member

      Thanks for sharing and wish more coming 🙂

      Author's profile photo Former Member
      Former Member

      Another work around to show up the alerters functionality in Charts.

      Very well demonstared Satish. Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Thank you Satish for sharing "Aleters in WebI 4.0 Charts" article with us.

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Thanks to one and all .

      Author's profile photo Former Member
      Former Member

      Thanks for sharing !!!

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing  🙂

      Author's profile photo Koen Hesters
      Koen Hesters

      great stuff, never thought of it, thanks for sharing!!

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Glad to know you liked it Koen . 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot! Just want to share that we can also use Stacked column chart, so each bar can be in the middle.

      Author's profile photo Former Member
      Former Member

      Hi Sateesh,

      I have requirement of conditional coloring in line chart. Read your blog but my requirement is little different. Can you please check my thread below and provide your valuable inputs.

      Webi Line chart report

      Regards,

      Swati

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi Swati ,

      Can you post sample screen of your req.

      Author's profile photo Former Member
      Former Member

      Thanx for sharing...

      Author's profile photo Former Member
      Former Member

      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