Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Display actual value and percentage in OBIEE 100% stacked bar chart?

Received Response
272
Views
7
Comments
Mourya
Mourya Rank 2 - Community Beginner
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi All,

We have built a 100% stacked bar chart in OBIEE 11g with data markers set to "Always show", but they only display % values inside the bars. One of our customers requested for the actual value too to be displayed alongside the % value within the same chart. I have looked through all the options that the graph offers on the front end but could not find one which allows both the values to be displayed. Is there a way we can add the actual value too to be displayed alongside the % in the 100% stacked bar chart?

Thanks,

Mourya

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    2016-01-13 15_13_27-Oracle BI Answers.png

    I just built this in SampleApp v406 (OBIEE 11.1.1.7.x) ... I made no special adjustments and I see the raw value and the % in the mouse over display.  What version are you running?

  • Mourya
    Mourya Rank 2 - Community Beginner

    Thomas,

    We need the same functionality when the data markers are set to show "Always" not on the mouse hover (raw values and percentage should be displayed always inside the bars). Do you know if there is a way to do that? We are on the same version of OBIEE.

  • Mourya
    Mourya Rank 2 - Community Beginner

    Thomas,

    We need the same functionality when the data markers are set to show "Always" not on the mouse hover (raw values and percentage should be displayed always inside the bars). Do you know if there is a way to do that? We are on the same version of OBIEE.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    First you have to get the percentange, get a SUM( MEASURE BY DIMENSION) to GET THE TOTAL, and

    Make a formula like this:

    measure /SUM( MEASURE BY DIMENSION)


    En sure your "AggregationRule(Totals Row)"

    PorcentajeForm.png

    And you can get the percentage:

    Porcentaje.png

    Kind Regards,

  • Mourya
    Mourya Rank 2 - Community Beginner

    It is not just the % but we need the raw value and the % on the graph itself. Not in a separate table. I have attached an image for reference. How can we achieve the same in OBIEEExample.JPG

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Sadly, in the standard view of bar stack of 100%, you cant do it.

    As a workaround you could create a "VIEW SELECTOR" to show with one stacked bar with ·PERCENTAGE" and antoher stacked bar with "ACTUAL VALUE", and put this as a DATA MARKETS properties as SHOW DATA LABELS "Always".

    If this a compulsory requirement with your client, maybe you have to create a 3rd-Party Visualization, with javascript and you could create a customize view that you need.

    Please follow these links:

    https://github.com/mbostock/d3/wiki/Gallery

    https://medium.com/red-pill-analytics/3rd-party-visualizations-in-obiee-18478d45cae3#.9qytwnbp0

    Kind Regards,

  • Mourya
    Mourya Rank 2 - Community Beginner

    Thanks for the reply Cesar,

    We already did the visualizations with the javascript. The problem with that is we are not able to send the content inline in email to our customers. Only the default OBIEE visualizations allow the inline content to be displayed properly. When sending javascript, the content is lost altogether in the email. I hope Oracle does something to get this feature implemented. If they are able to display both in the mouse over view, i believe it is simple to get it done in the "Always Show" view as well. Fingers crossed.

    Regards,