Stacked Bar Chart with Multiple Nodes - how to reference in rtf
Hi,
Does anyone know how to modify a Stacked Bar Chart (with XML that has multiple nodes). I'm using the BI Publisher Chart Wizard to create the rtf bones, then trying to modify it to reference the correct nodes, so far unsuccessful. (Oracle BI Publisher Desktop 12.2.1.4.0)
Here's what the XML looks like ... Trying to stack by APPL_STATUS_DESC for each RECRUITER_NAME (and sum NUM_APPL_STATHIST for each status) ...
Something like this (but with correct data) ...
Here's the XSL ...
<Graph depthAngle="50" depthRadius="8" seriesEffect="SE_AUTO_GRADIENT"><LegendArea visible="true"/>
<LocalGridData colCount="{count(xdoxslt:group(.//OC_APPSTATH_MW, 'RECRUITER_NAME'))}" rowCount="{count(xdoxslt:group(.//OC_APPSTATH_MW, 'APPL_STATUS_DESC'))}">