Skip to Content
1

Design Studio: Is it possible to show another measure in Infochart tooltip than reffered measure?

Nov 15, 2016 at 12:21 PM

275

avatar image

Hi,

I have a challenge which I think isn't possible but... why don't give it a try...

I have an InfoChart which shows cumulative values of project results. The data looks like this:

project	result	cumulative
a	10	10
b	8	18
c	8	26
d	6	32
e	5	37
f	4	41
g	4	45
h	2	47

So in my InfoChart it shows a line with values of column cumulative. Now the user wants to show the actual result of a project in the tooltip. So when hovering the mouse on a data point for lets say project F, in this example the tooltip shows 41. But is it possible with some code to show the non-cumulative value 4 instead? The column is available in the query but hidden via data selection.

Hope someone knows how to achieve this.

Thanks!!

Daan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Nov 15, 2016 at 12:54 PM
0

Out of the box, I can't see how; perhaps others have ideas

You could also look at extensions such as https://visualbi.com/wp-content/uploads/visualbi-extensions-for-sap-businessobjects-design-studio-vbx-user-guide.pdf or https://analytics-extensions.enter.sap

But one thing I remember from attending conferences - tool tips won't show up on a mobile device, so that is something for your end user to consider.

Share
10 |10000 characters needed characters left characters exceeded
Poovarasan Boopalan Nov 15, 2016 at 01:49 PM
0

Hi Daan,

You can achieve it using two charts placed one over other.

place a chart2 with measure 2 over your chart1 having measure 1. Then hide the columns in chart on top using the css

.bar g.v-datapoint

{ fill: white;

opacity: 0.01; }

Then the chart below will show data of measure1 but tooltip will show measure 2.

I used this work around for a requirement similar to yours.

let me know if you need any clarification in it.

Thanks,

Poovarasan

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks, I will try this as soon as possible!

But if I think about it, the chart I need to show is a cumulative line with data points (they call it an "elephant chart" because it first raises the values because positive results of projects and then it flattens because projects with zero result en then it descends because of negative project results (it will form the shape of an elephant...).

But if I make a chart2 which is overlaying the elephant chart but with the absolute non-cumulative measure, the line is never equal to the elephant and has different axis scaling and it will always descend because the data is sorted descending. So how can it display the tooltip on a datapoint in the elephant with the overlaying line info?

See image below (ignore the paint, but it's to indicate why they call it an elephant)

elephant-sap.jpg (101.6 kB)
0

Hi Daan,

You can have any chart at below but the chart with measure that needs to be shown in tooltip have to be on top of it and the bars height have to be equal to complete height chart below(You can make use of scaling property to achieve it).

So the top tip will be shown on hovering anywhere on the position of the member.

In your case for member a in chart you will get tool tip on hovering anywhere on it.

So there will not be any issues in showing tooltip in chart.

Thanks,

Poovarasan

0