Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 15, 2016 at 12:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2016 at 01:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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