[solkatten]

I am trying to make a multi series chart but the error is somewhere in the xml code. CodeIgniter, PHP and the free version of FusionChart.

In my contoller file:

$chart="<chart labelDisplay='Rotate' slantLabels='1' rotateValues='1' yAxisMinValue='166000' caption='Tillgänglighet' subcaption='On monthly basis' xAxisName='Month' yAxisName='Tillgänglighet' numberPrefix='st'>";
 $sqlquery="SELECT O.SERVICE, O.DAT, NVL(O.AVAILABILITY, 0) AVAILABILITY, O.TARGET FROM OPERATIONS o ORDER BY O.SERVICE, O.DAT ";
 $this->load->model('stat_model');
  $data_stat['records_stat']=$this->stat_model->getAllStat2();
 $this->load->view('stat-view', $data_stat);

In my view file:

echo renderChartHTML("http://192.168.1.16/susanne/codeigniter/FusionCharts/MSColumn3D.swf", "", $records_stat, "myNext", 900, 600, true);

In my model file:

function getAllStat2(){

$SMSdb=$this->load->database('SMS', TRUE);
$query_stat=$SMSdb->query("select s.MONTH, s.SUBMITTED_CURRENT_YEAR as subcurr, s.SUBMITTED_PREVIOUS_YEAR as subpre, s.DELIVERED_CURRENT_YEAR, s.DELIVERED_PREVIOUS_YEAR, CASE WHEN s.DELIVERED_CURRENT_YEAR > 0 THEN round((s.DELIVERED_CURRENT_YEAR/s.SUBMITTED_CURRENT_YEAR)*100,0) ELSE 0 END as OK_CURRENT_YEAR, CASE WHEN s.DELIVERED_PREVIOUS_YEAR > 0 THEN round((s.DELIVERED_PREVIOUS_YEAR/s.SUBMITTED_PREVIOUS_YEAR)*100,0) ELSE 0 END as OK_PREVIOUS_YEAR from SMSC_IC_MONTH s");

$data = "<chart labelDisplay='Rotate' slantLabels='1' rotateValues='1' yAxisMinValue='166000' caption='Tillgänglighet' subcaption='On monthly basis' xAxisName='Month' yAxisName='' numberPrefix=''>";
$data.="<categories><category label='Jan' /><category label='Feb' /><category label='Mars' /><category label='Apr' /><category label='Maj' /><category label='Jun' /><category label='Jul' /><category label='Aug' /><category label='Sep' /><category label='Okt' /><category label='Nov' /><category label='Dec' /></categories>";
$dataset1="<dataset seriesName='Submitted current year' />";
$dataset2="<dataset seriesName='Submitted previous year' />";

foreach($query_stat->result() as $row){
  $dataset1 .= "t<set value='".$row->SUBCURR."' />";
$dataset2 .= "t<set value='".$row->SUBPRE."' />";
}

$dataset1.="</dataset>";
$dataset2.="</dataset>";
$data.=$dataset1 . $dataset2;
$data.= "</chart>";
 
return $data;
}

It works with single serie chart, the values come from the database I can se them in View Source on the web page.

[solkatten]

I found the error:

$dataset1="<dataset seriesName='Submitted current year' />";
$dataset2="<dataset seriesName='Submitted previous year' />";

should be

$dataset1="<dataset seriesName='Submitted current year' >";
$dataset2="<dataset seriesName='Submitted previous year' >";

Now is it working.

[Rajroop]

Hey,



That's great!



As a friend of mine once said, 'Some people are self-healing'!



Happy FusionCharting.