Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Query on Pie Chart creation with data in different format

I have data in different format, like as below:
Attribute Null percent (in %)
---------------- ---------------------------
Status 12.83
Location 7.12
.......... .........
.......... so on
This null percent is actually percentage of null occurrence for that variate/attribute with respect to total number of records in the sample (subset) taken from the population.
I want to show this percentage in pie chart with one pie chart for one each attribute. So, in this case there will be two pie chart, one for status and one for Location.
The data above is simply percent value, it does not talk of rest of the remaining percent for each attribute ( for Status say 100 - 12.83 = 87.27). Can I draw a pie chart assuming the whole circle as 100% and this 12.83% as one slice (so basically two slice with one of 12.83 and the remaining 87.27 as another bigger slice).
I am using 11g.
Please suggest.
Answers
-
Just add a new column to your criteria and edit the formula to be 100 - "Null percent (in %)".
In your pie chart properties you use the "Measure Labels" as slices and set "Attribute" as pies.
(12c or 11g is the same for this ...)
0 -
Hi,
I think that one way to do this is create column 100 - Null percent (in %) like you said beacause Pie Chart in obiee does not have the possibility of a global scope settings as 100%.
Why do not you want to use such a solution?
.
0 -
Thanks. adding additional column works, I had to place measure labels in slices.
0