Ring Chart Oracle Bi Publisher RTF

_vero_

Hello Team,

we would like to modify a ring graph on Oracle Bi Publisher RTF.

In the following image there is the current graph.

We would like to obtain something like this:

reducing the thickness of the graph and increasing the font for 100 in the center, also adding % to the label. How can I modify the xml to get a similar result? I can't find anything about it

The XML code:

<Graph seriesEffect="SE_NONE" graphType= "RING_MULTI"><LegendArea visible="false"/>

<Title text="weekly" visible="true" horizontalAlignment="CENTER">
<GraphFont size="36" bold="false" italic="false" underline="false" fontColor="#4682B4"/>
</Title>
<SeriesItems><Series id="0" color="#4682B4"/><Series id="1" color="#F0F8FF"/></SeriesItems>
<PieLabel>
<GraphFont size="36" bold="false" italic="false" underline="false" fontColor="#4682B4"/>
</PieLabel>
<SliceLabel visible="false">
</SliceLabel><LocalGridData colCount="{count(xdoxslt:group(.//DATASET_OEE, 'TAG_OEE'))}" rowCount="2">
<RowLabels><Label>OEE</Label>
<Label>_100_OEE</Label></RowLabels>
<ColLabels><xsl:for-each-group select=".//DATASET_OEE" group-by="TAG_OEE"><Label><xsl:value-of select="current-group()/TAG_OEE"/></Label></xsl:for-each-group></ColLabels>
<DataValues><RowData><xsl:for-each-group select=".//DATASET_OEE" group-by="TAG_OEE"><Cell><xsl:value-of select="sum(current-group()/OEE[.!='']) div count(current-group()/OEE[.!=''])"/></Cell></xsl:for-each-group></RowData><RowData><xsl:for-each-group select=".//DATASET_OEE" group-by="TAG_OEE"><Cell><xsl:value-of select="sum(current-group()/_100_OEE[.!='']) div count(current-group()/_100_OEE[.!=''])"/></Cell></xsl:for-each-group></RowData></DataValues>
</LocalGridData>
</Graph>

Thanks in advance

Riyaz Ali-Oracle

You can try the below options:

1. Reduce Ring Thickness

Modify the graphType attribute to RING_SINGLE instead of RING_MULTI to control thickness.
Adjust the series size using the PieSliceDepth attribute.

2. Increase Font Size for Center Value (100)

Modify the <GraphFont> size inside the <Title> tag.

Example:

xml
<Title text="weekly" visible="true" horizontalAlignment="CENTER">
<GraphFont size="48" bold="true" fontColor="#4682B4"/>
</Title>

3. Add Percentage to Labels

Modify the <PieLabel> section to include a percentage format.

Example:

xml
<PieLabel>
<GraphFont size="36" bold="true" fontColor="#4682B4"/>
<LabelFormat>##0%</LabelFormat>
</PieLabel>

You can find more details on modifying BI Publisher RTF ring graphs in this Oracle discussion and documentation:

https://community.oracle.com/products/oracleanalytics/discussion/24196/ring-chart-oracle-bi-publisher-rtf

https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#BIPRD2354