Pie Chart
we have insert the pie chat in the BI Publisher. but we want set the color code for example when report_status= sucess then Greencolor, report_status= failed then red color and report_status='other' then grey color.
how to handle this in pie charts.
and one more thing the order of teh report_status is different. like one time may be sucess,failed and other or failed,sucess and other or failed and sucess.
Please find code of Chart.
chart:
<Graph stylePath="/oracle/dss/graph/styles/glass.xml" depthAngle="50" depthRadius="8" pieDepth="30" pieTilt="20" seriesEffect="SE_AUTO_GRADIENT" graphType="PIE"><LegendArea visible="true" /><Title text="Schedule Information" visible="true" horizontalAlignment="CENTER"><GraphFont name="Arial" size="12" bold="true" italic="false" underline="false" fontColor="#000000" /></Title><SeriesItems><Series id="0" color="#FF0000" /><Series id="1" color="#FF8000" /><Series id="2" color="#00FF00" /></SeriesItems><LocalGridData colCount="1" rowCount="{count(xdoxslt:group(.//ROW, 'REPORT_STATUS'))}"><RowLabels><xsl:for-each-group select=".//ROW" group-by="REPORT_STATUS" xmlns:xsl="