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
Thanks for sharing...:)
You are welcome
Great Attempt.. Thanks for Sharing . 🙂
Nice blog.. thanks for the workaround..
Nice presentaioon
Thanks for sharing and wish more coming 🙂
Another work around to show up the alerters functionality in Charts.
Very well demonstared Satish. Thanks for sharing.
Thank you Satish for sharing "Aleters in WebI 4.0 Charts" article with us.
Thanks to one and all .
Thanks for sharing !!!
Thanks for Sharing 🙂
great stuff, never thought of it, thanks for sharing!!
Glad to know you liked it Koen . 🙂
Thanks a lot! Just want to share that we can also use Stacked column chart, so each bar can be in the middle.
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
Hi Swati ,
Can you post sample screen of your req.
Thanx for sharing...
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).
Finally The chart looks like below.

Thanking You.
Regards,
Thiru