Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

chart dynamic row count

Question
1
Views
0
Comments

Summary

chart dynamic row count Content

hi i want to change the row count dynamically in run time with if conduction

if     rowCount="{count(xdoxslt:group(current-group(),  'GRP'))}"   grater than or equal  5 so the row count will be 5

if     rowCount="{count(xdoxslt:group(current-group(),  'GRP'))}"   less    than 5 so the row count will be the same of {count(xdoxslt:group(current-group(),  'GRP'))}

thanks

------------------------------------------------------------------------------

chart:

<Graph graphType="PIE" stylePath="/oracle/dss/graph/styles/april.xml" depthAngle="50" depthRadius="8" pieDepth="30" pieTilt="20" seriesEffect="SE_AUTO_GRADIENT">

<Title text="" visible="true" horizontalAlignment="CENTER"/>

<LocalGridData colCount="1" rowCount="5">

<RowLabels>

<xsl:for-each-group xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="current-group()" group-by="GRP">

<xsl:sort select="sum(current-group()/C_BUDG)" data-type="number" order="descending" />

<Label>

<xsl:value-of select="current-group()/GRP"/>><xsl:value-of select='format-number(sum (current-group()/C_BUDG), "###,###")' />

</Label>

</xsl:for-each-group>

</RowLabels>

<DataValues>

<xsl:for-each-group xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="current-group()" group-by="GRP">

<xsl:sort select="sum(current-group()/C_BUDG)" data-type="number" order="descending" />

<RowData>

<Cell>

<xsl:value-of select="sum(current-group()/C_BUDG)"/>

</Cell>

</RowData>

</xsl:for-each-group>

</DataValues>

</LocalGridData>

</Graph>