Skip to Content
Author's profile photo Former Member

Alerts in Web Intelligence Charts? Say Yes.

Hello All,

 

I’m going to explain how to implement the Alerts in WebI charts in the blog. This is a work around.

 

I’m going to use eFashion UNV to demonstrate this with an example.

 

1) Add a simple query with two result object Year and Sales Revenue to your data set.

2) Create Three variables like below
    Target: =10000000
Above Target
:=If [Sales revenue]>=[Target] Then [Sales revenue]
    Below Target : If [Sales revenue]<[Target] Then [Sales revenue]

3) Insert a stacked column chart and assign data as shown below

    Category axis: [Year]

    Value Axis1 : add three variables [Target] ,[Above Target] and [Below Target]

   Then apply and click on Ok.

   AssignData.png

4) Now go to Format Chart -> Global -> Region type -> change Target Measure region type to Line (see below Image).

 

     Target.PNG

     You need to change column colors under palette and style -> Color Palette to Palette Hue 2 to show it in the required column colors.

 

5) Finally the Chart looks like below(Alerts are applied)

    If the sales revenue is below 10 millions it shows Red else Green and we can also see the Target line.

   FinalChart.png

That’s it you’re done.

If you like this post please give 5 rating.

 

Thanking You All

 

Regards,

Thiru

 

Assigned tags

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

       

      Anurag,

      Thank You.

      Please like the post.

      Author's profile photo Former Member
      Former Member

      Awesome workaround. Good use of formatting...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Niraj,

      Thank You.

      Please like the post.