Query on Pie Chart creation with data in different format

A Anand Singh

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.

Gianni Ceresa

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

choracy69

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?

.

A Anand Singh

Thanks. adding additional column works, I had to place measure labels in slices.