Hi, I again met with the issue with the sorting by the column that consists some dates
Here is my code
$this->src('DB')
->query($query4)
->params($q_params)
->pipe(new Cube(array(
'row' => 'date',
'column' => 'server',
'sum' => 'averageInvoicePerGuest'
)))
->pipe(new DateTimeFormat(array(
'date' => array(
'from' => 'Y-m-d H:i:s',
'to' => 'd/m/Y',
)
)))
->pipe(new ColumnMeta(array(
'{{all}}' => array(
'label' => 'Total',
),
)))
->pipe(new Sort(array(
'date' => 'asc'
)))
->pipe($this->dataStore('myDStore'));
I tried to change the processes order but without any result I always get something like this