Hi,
First of all thanks a lot for all your support and this great framework. As explained sooner, I got two columns, 2 types of sales person, with an amount of sells. Sometime the sell is made by just one of them, and sometime by both. So I would to regroup the 2 types in one column and make the sum of their sells. So here is the code :
$this->src('sales')
->pipe(new Group(array(
"by"=>"Ccial",
"sum"=>"Marge_FAS_Déclarée",
)))
->pipe(new ColumnMeta(array(
"Ccial" => array(
"name" => "salesPerson"
)
)))
->pipe(new Sort(array(
"Marge_FAS_Déclarée"=>"desc"
)))
->pipe(new Filter(array(
"or",
array("Date","=","JANVIER"),
array("Date","=","FÉVRIER"),
array("Date","=","MARS"),
)))
->pipe($this->dataStore("SalesSum"));
$this->src('sales')
->pipe(new Group(array(
"by"=>"ACC",
"sum"=>"Marge_FAS_Déclarée",
)))
->pipe(new ColumnMeta(array(
"ACC" => array(
"name" => "salesPerson"
)
)))
->pipe(new Sort(array(
"Marge_FAS_Déclarée"=>"desc"
)))
->pipe(new Filter(array(
"or",
array("Date","=","JANVIER"),
array("Date","=","FÉVRIER"),
array("Date","=","MARS"),
)))
->pipe($this->dataStore("SalesSum"));
And on the view I have
BarChart::create(array(
"dataStore"=>$this->dataStore('SalesSum'),
"width"=>"100%",
"height"=>"500px",
"columns"=>array(
"salesPerson"=>array(
"label"=>"sales persons"
),
"Marge_FAS_Déclarée"=>array(
"type"=>"number",
"label"=>"Marge FAS Déclarée",
"prefix"=>"€",
"emphasis"=>true
)
),
"options"=>array(
"title"=>"Marge FAS Déclarée",
)
));
It almost work but there are some strange things. I got one of the sales person who doesn't appear, a line with no name which seems to be the total amount of all the sales and a line with no name.
What could be the mistake ?
Thanks !