Charting in Web Intelligence

[Former Member]

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

[former_member189638 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

jusr to add to Rakesh´s answer, you can also set a background picture to your table cells with an ellipsis so it would mimic more yoyr requirement.

Regards,

Rogerio

[Former Member]

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.

[former_member216148]

Hi.. Please check this link below.

BOBJ Tricks: Webi as a Dashboard

Warm Regards

Saad

[Former Member]

Hi Saad:

Thank you for your reply, I did not see what I am trying to do on this link

Brad