Sales SuperCube
Supporing multiple rows, columns and aggregates
Multi row fields (productLine, productName) SuperCube
->pipe(new SuperCube(array(
"rows" => "productLine, productName",
"sum" => "dollar_sales",
)))| productLine | productName | {{all}} - {{all}} | dollar_sales - sum |
|---|---|---|
| Classic Cars | 1992 Ferrari 360 Spider red | $276,840 |
| Classic Cars | 2001 Ferrari Enzo | $190,756 |
| Classic Cars | 1952 Alpine Renault 1300 | $190,018 |
| Motorcycles | 2003 Harley-Davidson Eagle Drag Bike | $170,686 |
| Classic Cars | 1968 Ford Mustang | $161,531 |
Multi column fields (Year, Quarter) SuperCube
->pipe(new SuperCube(array(
"columns" => "Year, Quarter",
"sum" => "dollar_sales",
)))| {{label}} | Year - {{all}} | dollar_sales - sum | Year - 2003 | dollar_sales - sum | Year - 2004 | dollar_sales - sum | Year - 2005 | dollar_sales - sum | Quarter - {{all}} | dollar_sales - sum | Quarter - 1 | dollar_sales - sum | Quarter - 2 | dollar_sales - sum | Quarter - 3 | dollar_sales - sum | Quarter - 4 | dollar_sales - sum |
|---|---|---|---|---|---|---|---|---|---|
| Total | $9,583,418 | $3,296,576 | $4,515,906 | $1,770,937 | $9,583,418 | $2,169,061 | $2,081,322 | $1,645,586 | $3,687,449 |
Multi aggregated fields (dollar_sales sum, count, average and sum percent) SuperCube
->pipe(new SuperCube(array(
"rows" => "customerName",
"sum" => "dollar_sales",
"count" => "dollar_sales",
"avg" => "dollar_sales",
'sum percent' => 'dollar_sales',
)))| customerName | {{all}} - {{all}} | dollar_sales - sum | {{all}} - {{all}} | dollar_sales - count | {{all}} - {{all}} | dollar_sales - avg | {{all}} - {{all}} | dollar_sales - sum percent |
|---|---|---|---|---|
| Euro+ Shopping Channel | $820,690 | 259 | $3,169 | 8.56% |
| Mini Gifts Distributors Ltd. | $591,827 | 180 | $3,288 | 6.18% |
| Australian Collectors, Co. | $180,585 | 55 | $3,283 | 1.88% |
| Muscle Machine Inc | $177,914 | 48 | $3,707 | 1.86% |
| La Rochelle Gifts | $158,573 | 53 | $2,992 | 1.65% |