Skip to Content
author's profile photo Former Member
Former Member

Charting in Web Intelligence

Good Morning:

I have a chart that is comparing two data points. been asked if there is a way to display the delta between the two vs above the absolute numbers.


so the green is actual and the blue is the target for each business.

Current Chart

Desired Chart

Thanks

Brad

Current Chart.png (35.3 kB)
Desired Chart.png (52.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 10, 2015 at 07:00 PM

    I don't think it is possible to have a chart exactly how you want it. But one workaround that I can think of is a horizontal table on top of the graph. Once you have the table properly aligned, you can even hide the unwanted columns or set the text and cell color to white so that they get disappeared as shown below.


    pic 1.jpg (32.3 kB)
    pic 2.jpg (27.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2015 at 06:32 PM

    Unfortunately the closest that I can get to what you want only works for positive values. I'm struggling to thinking of anything out of the box that would work for you.

    I've created the MTD value and the delta as a globally stacked bar on the first y-axis, the DF on the second then formatted the bar for delta to be invisible and showing labels. As I said, this works fine for positive deltas - you may be able to get almost what you want with an absolute delta? you'll probably also need a spacer dummy value to get the delta values above your column labels. It won't look pretty as it doesn't have the rounded borders and drop shadow but it can get close to what you want.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 10, 2015 at 05:37 PM

    Hi.. Please check this link below.

    BOBJ Tricks: Webi as a Dashboard

    Warm Regards

    Saad

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.