How to just show the integer value of "MarkerText" in my chart?
616254Jan 15 2008 — edited Feb 6 2009I put the tag of "MarkerText " in my BAR_HORIZ_CLUST. Then I can successfully get the values on my bar. But the point of decimal is not good. I just want to show the integer of the number(In fact, all of our value are integer. For example, I have a value "7". But it shows me "7.000" ). I searched a url to do it: http://blogs.oracle.com/xmlpublisher/2007/05/15#a293. But it is only available for pie. With regard to my BAR_HORIZ_CLUST, I cann't find any way to do it.
This is my sample file:
Chart Definition:
chart:
<Graph graphType="BAR_HORIZ_CLUST">
<MarkerText visible="true" markerTextPlace="MTP_CENTER"/>
<Title text="Requests Closed" visible="true" horizontalAlignment="CENTER"/>
<LocalGridData colCount="{count(xdoxslt:group(.//ROW, 'AGENTNAME'))}" rowCount="1">
<RowLabels>
<Label>amout of closed requests</Label>
</RowLabels>
<ColLabels>
<xsl:for-each-group xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select=".//ROW" group-by="AGENTNAME">
<xsl:sort select="current-group()/AGENTNAME"/>
<Label><xsl:value-of select="current-group()/AGENTNAME"/></Label>
</xsl:for-each-group>
</ColLabels>
<DataValues>
<RowData>
<xsl:for-each-group xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select=".//ROW" group-by="AGENTNAME">
<xsl:sort select="current-group()/AGENTNAME"/>
<Cell><xsl:value-of select="current-group()/AMOUNT"/></Cell>
</xsl:for-each-group>
</RowData>
</DataValues>
</LocalGridData>
</Graph>
I modified the tag of "MarkerText" as below but still not available :(
<MarkerText visible="true" markerTextPlace="MTP_CENTER">
<X1ViewFormat>
<ViewFormat decimalDigit="0" decimalDigitUsed="true" decimalSeparatorUsed="true" />
</X1ViewFormat>
</MarkerText>