How to calculate sum of all values of Y axis for column3D chart.

[raxdex]

e.g <graph xAxisName='Month' yAxisName='No. of Items' decimalPrecision='0' formatNumberScale='0'><set name='Jan' value='45' color='AFD8F8' /><set name='Feb' value='49' color='F6BD0F' /><set name='Mar' value='42' color='8BBA00' /><set name='Apr' value='25' color='FF8E46' /><set name='May' value='43' color='008E8E' /><set name='Jun' value='22' color='D64646' /><set name='Jul' value='48' color='8E468E' /><set name='Aug' value='46' color='588526' /><set name='Sep' value='24' color='B3AA00' /><set name='Oct' value='45' color='008ED6' /><set name='Nov' value='42' color='9D080D' /><set name='Dec' value='32' color='A186BE' /></graph>

here i want o/p as : (45+49+42+25+43+22+48+46+24+45+42+32) = 463 in javascript variable

e.g var val ;

[Guest Madhumita]

Hello,

Welcome to FusionCharts Forum.

Our charts  do not support aggregate functions.

However, you can write your own javascript function to achieve this.

You can follow the steps below to achieve this:

1. getXML

2. build a javascript function say getSum()

3. Parse through the XML and retrieve the value in the value attribute

4.While retrieving the values keep adding them to a variable say sum

5.return the sum to the browser

Hope this helps.

[raxdex]

Hi, Madhumita

Thanks for u r urgent reply. I am new in this area so please help me out.

You said regarding getXML method to retrive data from graph.

can u plz give me getSum() function code specifically getXML method for column2D graph.

[Guest Madhumita]

Hello,

Here is a piece of code to help you:

<script type="text/javascript">

  FusionChartsGetValues = function(sourceXML) {

  if(typeof sourceXML != 'string') {

  throw "ArgumentException() :: sourceXML is nopt string.";

  }

  var r = [];

  var a = sourceXML.replace(/<set.+?value="(.+?)"|<set.+?value='(.+?)'/ig,

  function($1, $2, $3) {

  r.push(parseInt($2 || $3));

  });

  return r;

  };

  function getSum(fromXML) {

  var a = FusionChartsGetValues(fromXML), s=0;

  while(a.length) { s+= a.pop(); }

  return s;

  }

  alert(getSum("<graph xAxisName='Month' yAxisName='No. of Items' decimalPrecision='0' formatNumberScale='0'><set name='Jan' value='45' color='AFD8F8' /><set name='Feb' value='49' color='F6BD0F' /><set name='Mar' value='42' color='8BBA00' /><set name='Apr' value='25' color='FF8E46' /><set name='May' value='43' color='008E8E' /><set name='Jun' value='22' color='D64646' /><set name='Jul' value='48' color='8E468E' /><set name='Aug' value='46' color='588526' /><set name='Sep' value='24' color='B3AA00' /><set name='Oct' value='45' color='008ED6' /><set name='Nov' value='42' color='9D080D' /><set name='Dec' value='32' color='A186BE' /></graph>"));

  </script>

Here in the getSum() , use getXML function to get the XML from the chart.

Hope this helps.

[raxdex]

Hi Madhumita,

Again Thanks for u r urgent reply.

It really helped me. It was not possible without your help !

Once again Thank you so much.....

Regards,

RxDx

[Guest Madhumita]

Hello,

You are most welcome.

Glad that I could help you.

Happy FusionCharting.