Oracle Analytics Cloud and Server

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

Stacked Charts with Totals

Received Response
51
Views
1
Comments
jmarc
jmarc Rank 4 - Community Specialist

Summary

Stacked Charts with Totals

Content

hello,

i find an article that concerns a  way to add total to stacked chart

https://blogs.oracle.com/xmlpublisher/stacked-charts-with-totals

but the download sample 
http://blogs.oracle.com/xmlpublisher/resource/files/stackedbar.zip
is unreacheable. 

Is it possible to reactivate the dead link ?

best regards

jm

Tagged:

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    From what i understand, just generate the data with some total value and then use the following calc to make it work

     <Cell><xsl:value-of select="VAL1+VAL2" /></Cell>

     

    We also set the val2 and val2 values to be of type MT_BAR and the total to be MT_MARKER using the SeriesItems tag.

    In the example below I have thrown out the TOTAL value and replaced it with a calculation

     <Cell><xsl:value-of select="VAL1+VAL2" /></Cell>

    So we need the total value initially to get the chart dialog to build the data portion of the chart XML. Then we can modify the XML with the calculation.

    --YG