Hi
I have problems with displaying the PivotMatrix. PivotTable works fine.
https://arhiv.obscv.si/reports/meteor/index.php
Below the PivotTable I inserted the same code for a PivotMatrix
This is par of my MeteorCount.view.php
use \koolreport\pivot\widgets\PivotTable;
use \koolreport\pivot\widgets\PivotMatrix;
PivotTable::create(array(
"dataStore"=>$this->dataStore('met_count'),
'totalName' => 'Total',
'rowCollapseLevels' => array(2),
));
PivotMatrix::create(array(
"dataStore"=>$this->dataStore('met_count'),
'rowCollapseLevels' => array(2),
));
And my MeteorCount.php has this query stored to dataStore
function setup()
{
$this->src('metrec')
->query("select observer,camera,YEAR(obs_date) as ObsYear,MONTH(obs_date) as ObsMonth,DAY(obs_date) as ObsDay,met_shower from meteor_data_query")
->pipe(new Pivot(array(
"dimensions" => array(
"column" => "met_shower",
"row" => "observer, camera, ObsYear, ObsMonth"
),
"aggregates"=>array(
"count" => "met_shower"
)
)))
->pipe($this->dataStore('met_count'));
}
--
From the html source it seems that the PivotMatrix object is created, but it is not displayed in the browser?
Halp would be appriciated. Best Jure