Hi,
I have csv file with 2 columns (Customer_id_customer, Contract_month_cost=number) I 've checked this csv file exists. In the view I have no data;
Below my class Report Do you have an idea ?
Thanks & regars
function settings()
{
return array(
"dataSources"=>array(
'mysource'=>array(
'class'=>'\koolreport\datasources\CSVDataSource',
'filePath'=> 'xxxxxx.csv',
)
)
);
}
function setup()
{
$this->src("mysource")
->pipe(new ColumnMeta(array(
"Contract_month_cost"=>array(
"type" => "number",
),
)))
->pipe(new Pivot(array(
"dimensions"=>array("column" => null,"row" => "Customer_id_customer",
),
"aggregates"=>array(
"sum" => "Contract_month_cost"
)
)))
->pipe($this->dataStore("mysource"));
}