I've changed your drilldown Sale By Time example so that the second level is a table instead of a chart. Now I can't drilldown to the 3rd level as there is nothing to click on in the table.
how do I enable drilldown through a table please? My code is below.
<?php
DrillDown::create(array(
"name"=>"saleDrillDown",
"title"=>"Sale Report",
"btnBack"=>true,
"dataSource"=>(
$this->src('automaker')
->query("SELECT amount, paymentDate FROM payments")
->pipe(new CopyColumn(array(
"year"=>"paymentDate",
"month"=>"paymentDate",
"day"=>"paymentDate",
)))
->pipe(new DateTimeFormat(array(
"year"=>"Y",
"month"=>"m",
"day"=>"d",
)))
),
"calculate"=>array(
"sum"=>"amount"
),
"levels"=>array(
array(
"groupBy"=>"year",
"widget"=>array(ColumnChart::class,array(
"columns"=>array("year","amount"=>array(
"label"=>"Amount",
"prefix"=>'$'
)),
"colorScheme"=>array("#3b9b00"),
)),
"title"=>"All Years",
),
array(
"groupBy"=>"month",
"widget"=>array(Table::class,array(
"columns"=>array(
"month"=>array(
"label"=>"Month"
),
"amount"=>array(
"type"=>"number",
"label"=>"Amount",
"prefix"=>"$"
)), # End of columns
"title"=>function($params)
{
return "Year ".$params["year"];
},
)),
),
array(
"groupBy"=>"day",
"widget"=>array(ColumnChart::class,array(
"columns"=>array("day","amount"=>array(
"label"=>"Amount",
"prefix"=>'$'
)),
"colorScheme"=>array("#e0dc00"),
)),
"title"=>function($params)
{
return date('F', mktime(0, 0, 0, $params["month"], 10));
},
),
),
));
?>