I'm sorry to ask for this question that could be trivial but I can't solve it and clear it:

I've a simple table that works like this

Table::create(array(
    "dataStore"=>$this->dataStore('amb_mod'),
    "columns"=>array(			
		"mydatefield"=>array(
			"label"=>"DATA",
			"type"=>"datetime",		
			),
        "mycustomerfield"=>array(
            "label"=>"CLIENTE",
            "type"=>"text",
        ),
        "myquantityfield"=>array(
            "label"=>"QUANTITA'",
            "type"=>"number",
                    )
    ),
    "cssClass"=>array(
        "table"=>"table table-hover table-bordered"
    )
));

I would like to make a BarChart and tried to make it simple by copying by example

BarChart::create
(
	array(
		"dataStore"=>$this->dataStore('amb_mod'), 
		"columns"=>array(
			"mycustomerfield"=>array(),	
			"myquantityfield"=>array()        		
		),		
		"width"=>"100%",
		"height"=>"500px"	
	)
);

But I get a js error in browser console: Uncaught SyntaxError: Unexpected token That's because the generated code is like this: `

googleChartLoader.load("current","corechart");

var gchart5ac602a18d9271 = new GoogleChart("BarChart","gchart5ac602a18d9271",,[]);        

Data param seems to be missing, why ?

There should be something related with aggregated data, because if in results there is only one (!) distinct mycustomerfield value the BarChart shows up !!

I'm sorry again, could you please give any suggestion ?

Well I purchase the ChartJS package as it will be useful in anyway, hoping to solve this issue with BarChart

Hello, no it didn't solve, there should be something related with data aggregation on customer name field. I display data in table without specific problem related to that field (see attached screenshots) As you could see I create ColumnChart without problems, but here I don't set customer name field (ANDESCRI).

		->pipe(new Group(array("by"=>"ANDESCRI","sum"=>"MVQTAMOV")))		
 
 		->pipe(new CalculatedColumn(array(
			"valore"=>"({MVQTAMOV}*{MVPREZZO}*((100-{MVSCONT1})/100)*((100-{MVSCONT2})/100)*((100-{MVSCONT3})/100)*((100-{MVSCONT4})/100))" //
		)))	
        
		->pipe(new AggregatedColumn(array(
			"total"=>array("sum","MVQTAMOV")
		)))	
		->pipe(new CalculatedColumn(array(
			"PERC"=>"{MVQTAMOV}*100/{total}"
		)))				
		->pipe(new AggregatedColumn(array(
			"totalv"=>array("sum","valore")
		)))	
		->pipe(new CalculatedColumn(array(
			"PERCV"=>"{valore}*100/{totalv}"
		)))	
										
		->pipe(new Sort(array($sort=>$sortdir)))	

		->pipe($this->dataStore('amb_mod'));

  BarChart::create(array(
        "dataStore"=>$this->dataStore('amb_mod'), 
        "width"=>"100%",
        "height"=>"500px",
        "columns"=>array(
            "ANDESCRI",
      		"MVQTAMOV"
        ),
        "options"=>array(
            "title"=>"Sales By Customer",
        )
    ));

Doing other testing it shows that is don't works only when I set as first field a specific field of my db (the customer name), I don't know what it could be... I'm on a SQL Server 2008 and the field is a char(60)

Yes, it is as you described. I've now tested trying in some ways to remove any single quote: - by replacing in query - by excluding by query - by replacing with Pipe Custom field but nothing changed

Yes, thank you so much !!

Hello, did you find any solution ? Is it possible that a Ü makes the issue ?

I confirm that filtering out the customer with that char the BarChart works fine !! It is really bad encoded because also on the table it cannot be readed...any solution to also "bad-view" that char also by the chart ?

It works !! Thank you !!