nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Mourya

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

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

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

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

Thomas,

cesar.advincula.o

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)"

And you can get the percentage:

Kind Regards,

Mourya

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 OBIEE

cesar.advincula.o

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

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,