Skip to content

Instantly share code, notes, and snippets.

@ramnathv

ramnathv/chart1.html

Created September 2, 2013 10:05
Show Gist options
  • Save ramnathv/6411290 to your computer and use it in GitHub Desktop.
Save ramnathv/6411290 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
chart1.html
<!doctype HTML>
<meta charset = 'utf-8'>
<html>
<head>
<script src='http://d3js.org/d3.v3.min.js' type='text/javascript'></script>
<script src='http://dimplejs.org/dist/dimple.v1.min.js' type='text/javascript'></script>
<style>
.rChart {
display: block;
margin-left: auto;
margin-right: auto;
width: 590px;
height: 400px;
}
</style>
</head>
<body>
<div id='chart6e845a8c63d5' class='rChart dimple'></div>
<script type="text/javascript">
var opts = {
"dom": "chart6e845a8c63d5",
"width": 590,
"height": 400,
"x": "Price",
"y": "SalesValue",
"groups": [ "SKU", "Channel", "Owner" ],
"type": "bubble",
"bounds": {
"x": 60,
"y": 30,
"width": 420,
"height": 330
},
"id": "chart6e845a8c63d5"
},
data = [
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Delta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Delta 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 1553,
"SalesValue": 88223,
"Distribution": 98.19,
"CostofSales": 224.14,
"Price": 56.81,
"GrossProfit": 87999,
"IndirectCosts": 82160,
"OperatingProfit": 5838.9,
"UnitSalesMonthlyChange": 81,
"SalesValueMonthlyChange": 4492,
"DistributionMonthlyChange": 0.64,
"CostofSalesMonthlyChange": 11.42,
"PriceMonthlyChange": -0.07,
"GrossProfitMonthlyChange": 4480.6,
"IndirectCostsMonthlyChange": 4184,
"OperatingProfitMonthlyChange": 296.57
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Eta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Eta 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 928,
"SalesValue": 40885,
"Distribution": 17.48,
"CostofSales": 103.87,
"Price": 44.06,
"GrossProfit": 40781,
"IndirectCosts": 38075,
"OperatingProfit": 2705.9,
"UnitSalesMonthlyChange": 66,
"SalesValueMonthlyChange": 2829,
"DistributionMonthlyChange": 2.34,
"CostofSalesMonthlyChange": 7.19,
"PriceMonthlyChange": -0.09,
"GrossProfitMonthlyChange": 2821.8,
"IndirectCostsMonthlyChange": 2634.6,
"OperatingProfitMonthlyChange": 187.24
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Omicron 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 470,
"SalesValue": 41348,
"Distribution": 33.84,
"CostofSales": 105.05,
"Price": 87.97,
"GrossProfit": 41243,
"IndirectCosts": 38507,
"OperatingProfit": 2736.3,
"UnitSalesMonthlyChange": 180,
"SalesValueMonthlyChange": 15759,
"DistributionMonthlyChange": 3.44,
"CostofSalesMonthlyChange": 40.04,
"PriceMonthlyChange": -0.27,
"GrossProfitMonthlyChange": 15719,
"IndirectCostsMonthlyChange": 14676,
"OperatingProfitMonthlyChange": 1042.5
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Omicron 12 Pack Deluxe",
"PriceTier": "Regular",
"UnitSales": 721,
"SalesValue": 63070,
"Distribution": 48.42,
"CostofSales": 160.24,
"Price": 87.48,
"GrossProfit": 62910,
"IndirectCosts": 58736,
"OperatingProfit": 4174.3,
"UnitSalesMonthlyChange": 349,
"SalesValueMonthlyChange": 30535,
"DistributionMonthlyChange": 7.74,
"CostofSalesMonthlyChange": 77.58,
"PriceMonthlyChange": 0.02,
"GrossProfitMonthlyChange": 30457,
"IndirectCostsMonthlyChange": 28437,
"OperatingProfitMonthlyChange": 2020.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Omicron 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 7315,
"SalesValue": 620587,
"Distribution": 99.44,
"CostofSales": 1576.7,
"Price": 84.84,
"GrossProfit": 6.1901e+05,
"IndirectCosts": 5.7793e+05,
"OperatingProfit": 41076,
"UnitSalesMonthlyChange": 4604,
"SalesValueMonthlyChange": 385333,
"DistributionMonthlyChange": 0.23,
"CostofSalesMonthlyChange": 978.97,
"PriceMonthlyChange": -1.94,
"GrossProfitMonthlyChange": 3.8435e+05,
"IndirectCostsMonthlyChange": 3.5885e+05,
"OperatingProfitMonthlyChange": 25505
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Omicron 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 1766,
"SalesValue": 129609,
"Distribution": 50.03,
"CostofSales": 329.29,
"Price": 73.39,
"GrossProfit": 1.2928e+05,
"IndirectCosts": 1.207e+05,
"OperatingProfit": 8578.5,
"UnitSalesMonthlyChange": 918,
"SalesValueMonthlyChange": 67277,
"DistributionMonthlyChange": 8.73,
"CostofSalesMonthlyChange": 170.93,
"PriceMonthlyChange": -0.11,
"GrossProfitMonthlyChange": 67106,
"IndirectCostsMonthlyChange": 62654,
"OperatingProfitMonthlyChange": 4452.5
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Omicron 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 40370,
"SalesValue": 2379032,
"Distribution": 99.94,
"CostofSales": 6044.2,
"Price": 58.93,
"GrossProfit": 2.373e+06,
"IndirectCosts": 2.2155e+06,
"OperatingProfit": 1.5746e+05,
"UnitSalesMonthlyChange": -503,
"SalesValueMonthlyChange": -39845,
"DistributionMonthlyChange": 0.01,
"CostofSalesMonthlyChange": -101.23,
"PriceMonthlyChange": -0.25,
"GrossProfitMonthlyChange": -39744,
"IndirectCostsMonthlyChange": -37106,
"OperatingProfitMonthlyChange": -2637.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Sigma",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Sigma 12 Pack Giftset",
"PriceTier": "Premium",
"UnitSales": 2388,
"SalesValue": 355954,
"Distribution": 98.21,
"CostofSales": 904.34,
"Price": 149.06,
"GrossProfit": 3.5505e+05,
"IndirectCosts": 3.3149e+05,
"OperatingProfit": 23560,
"UnitSalesMonthlyChange": 837,
"SalesValueMonthlyChange": 123731,
"DistributionMonthlyChange": 1.91,
"CostofSalesMonthlyChange": 314.35,
"PriceMonthlyChange": -0.66,
"GrossProfitMonthlyChange": 1.2342e+05,
"IndirectCostsMonthlyChange": 1.1523e+05,
"OperatingProfitMonthlyChange": 8189.6
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Sigma",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Sigma 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 1663,
"SalesValue": 245351,
"Distribution": 98.66,
"CostofSales": 623.34,
"Price": 147.54,
"GrossProfit": 2.4473e+05,
"IndirectCosts": 2.2849e+05,
"OperatingProfit": 16239,
"UnitSalesMonthlyChange": 630,
"SalesValueMonthlyChange": 92337,
"DistributionMonthlyChange": 0.16,
"CostofSalesMonthlyChange": 234.59,
"PriceMonthlyChange": -0.59,
"GrossProfitMonthlyChange": 92102,
"IndirectCostsMonthlyChange": 85990,
"OperatingProfitMonthlyChange": 6112.1
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Aperture",
"Brand": "Tau",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Tau 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 589,
"SalesValue": 45364,
"Distribution": 92.22,
"CostofSales": 115.25,
"Price": 77.02,
"GrossProfit": 45249,
"IndirectCosts": 42246,
"OperatingProfit": 3002.3,
"UnitSalesMonthlyChange": 30,
"SalesValueMonthlyChange": 2436,
"DistributionMonthlyChange": -1.04,
"CostofSalesMonthlyChange": 6.19,
"PriceMonthlyChange": 0.23,
"GrossProfitMonthlyChange": 2429.8,
"IndirectCostsMonthlyChange": 2268.6,
"OperatingProfitMonthlyChange": 161.24
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Epsilon",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Epsilon 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 721,
"SalesValue": 38965,
"Distribution": 45.96,
"CostofSales": 98.99,
"Price": 54.04,
"GrossProfit": 38866,
"IndirectCosts": 36287,
"OperatingProfit": 2578.8,
"UnitSalesMonthlyChange": 127,
"SalesValueMonthlyChange": 6734,
"DistributionMonthlyChange": 0.66,
"CostofSalesMonthlyChange": 17.1,
"PriceMonthlyChange": -0.22,
"GrossProfitMonthlyChange": 6716.9,
"IndirectCostsMonthlyChange": 6271,
"OperatingProfitMonthlyChange": 445.89
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Iota",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Iota 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 1177,
"SalesValue": 114062,
"Distribution": 97.46,
"CostofSales": 289.79,
"Price": 96.91,
"GrossProfit": 1.1377e+05,
"IndirectCosts": 1.0622e+05,
"OperatingProfit": 7549.7,
"UnitSalesMonthlyChange": 591,
"SalesValueMonthlyChange": 56616,
"DistributionMonthlyChange": 3.71,
"CostofSalesMonthlyChange": 143.84,
"PriceMonthlyChange": -1.12,
"GrossProfitMonthlyChange": 56472,
"IndirectCostsMonthlyChange": 52724,
"OperatingProfitMonthlyChange": 3747.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Iota",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Iota 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 1384,
"SalesValue": 123644,
"Distribution": 98.4,
"CostofSales": 314.13,
"Price": 89.34,
"GrossProfit": 1.2333e+05,
"IndirectCosts": 1.1515e+05,
"OperatingProfit": 8183.9,
"UnitSalesMonthlyChange": 333,
"SalesValueMonthlyChange": 30877,
"DistributionMonthlyChange": 1.62,
"CostofSalesMonthlyChange": 78.44,
"PriceMonthlyChange": 1.07,
"GrossProfitMonthlyChange": 30799,
"IndirectCostsMonthlyChange": 28755,
"OperatingProfitMonthlyChange": 2044
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Lambda",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Lambda 8 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 796,
"SalesValue": 48595,
"Distribution": 42.62,
"CostofSales": 123.46,
"Price": 61.05,
"GrossProfit": 48472,
"IndirectCosts": 45255,
"OperatingProfit": 3216.8,
"UnitSalesMonthlyChange": -123,
"SalesValueMonthlyChange": -6366,
"DistributionMonthlyChange": -26.55,
"CostofSalesMonthlyChange": -16.17,
"PriceMonthlyChange": 1.24,
"GrossProfitMonthlyChange": -6349.8,
"IndirectCostsMonthlyChange": -5928.5,
"OperatingProfitMonthlyChange": -421.35
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Lambda",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Lambda 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 3245,
"SalesValue": 187067,
"Distribution": 99.71,
"CostofSales": 475.26,
"Price": 57.65,
"GrossProfit": 1.8659e+05,
"IndirectCosts": 1.7421e+05,
"OperatingProfit": 12382,
"UnitSalesMonthlyChange": 274,
"SalesValueMonthlyChange": 16015,
"DistributionMonthlyChange": 0.4,
"CostofSalesMonthlyChange": 40.69,
"PriceMonthlyChange": 0.08,
"GrossProfitMonthlyChange": 15974,
"IndirectCostsMonthlyChange": 14914,
"OperatingProfitMonthlyChange": 1060.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Mu",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Mu 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 614,
"SalesValue": 90866,
"Distribution": 66.91,
"CostofSales": 230.86,
"Price": 147.99,
"GrossProfit": 90635,
"IndirectCosts": 84621,
"OperatingProfit": 6013.8,
"UnitSalesMonthlyChange": 343,
"SalesValueMonthlyChange": 49419,
"DistributionMonthlyChange": 8.69,
"CostofSalesMonthlyChange": 125.56,
"PriceMonthlyChange": -4.95,
"GrossProfitMonthlyChange": 49293,
"IndirectCostsMonthlyChange": 46023,
"OperatingProfitMonthlyChange": 3270.9
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 6,
"PackType": "Standard",
"SKU": "Theta 6 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 305,
"SalesValue": 31113,
"Distribution": 20.6,
"CostofSales": 79.04,
"Price": 102.01,
"GrossProfit": 31034,
"IndirectCosts": 28975,
"OperatingProfit": 2059.3,
"UnitSalesMonthlyChange": 126,
"SalesValueMonthlyChange": 12752,
"DistributionMonthlyChange": 2.96,
"CostofSalesMonthlyChange": 32.39,
"PriceMonthlyChange": -0.57,
"GrossProfitMonthlyChange": 12720,
"IndirectCostsMonthlyChange": 11876,
"OperatingProfitMonthlyChange": 843.65
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Theta 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 4679,
"SalesValue": 344647,
"Distribution": 97.49,
"CostofSales": 875.61,
"Price": 73.66,
"GrossProfit": 3.4377e+05,
"IndirectCosts": 3.2096e+05,
"OperatingProfit": 22811,
"UnitSalesMonthlyChange": 1872,
"SalesValueMonthlyChange": 132030,
"DistributionMonthlyChange": -1.1,
"CostofSalesMonthlyChange": 335.44,
"PriceMonthlyChange": -2.09,
"GrossProfitMonthlyChange": 1.3169e+05,
"IndirectCostsMonthlyChange": 1.2296e+05,
"OperatingProfitMonthlyChange": 8738.2
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Theta 12 Pack Deluxe",
"PriceTier": "Regular",
"UnitSales": 1894,
"SalesValue": 155006,
"Distribution": 81.5,
"CostofSales": 393.81,
"Price": 81.84,
"GrossProfit": 1.5461e+05,
"IndirectCosts": 1.4435e+05,
"OperatingProfit": 10259,
"UnitSalesMonthlyChange": 1414,
"SalesValueMonthlyChange": 114224,
"DistributionMonthlyChange": 9.69,
"CostofSalesMonthlyChange": 290.2,
"PriceMonthlyChange": -3.12,
"GrossProfitMonthlyChange": 1.1393e+05,
"IndirectCostsMonthlyChange": 1.0637e+05,
"OperatingProfitMonthlyChange": 7559.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Theta 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 4281,
"SalesValue": 368994,
"Distribution": 99.39,
"CostofSales": 937.47,
"Price": 86.19,
"GrossProfit": 3.6806e+05,
"IndirectCosts": 3.4363e+05,
"OperatingProfit": 24423,
"UnitSalesMonthlyChange": 2374,
"SalesValueMonthlyChange": 191488,
"DistributionMonthlyChange": 0.85,
"CostofSalesMonthlyChange": 486.5,
"PriceMonthlyChange": -6.89,
"GrossProfitMonthlyChange": 1.91e+05,
"IndirectCostsMonthlyChange": 1.7833e+05,
"OperatingProfitMonthlyChange": 12675
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Theta 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 10676,
"SalesValue": 768425,
"Distribution": 99.98,
"CostofSales": 1952.3,
"Price": 71.98,
"GrossProfit": 7.6647e+05,
"IndirectCosts": 7.1561e+05,
"OperatingProfit": 50860,
"UnitSalesMonthlyChange": 2739,
"SalesValueMonthlyChange": 186789,
"DistributionMonthlyChange": 0.47,
"CostofSalesMonthlyChange": 474.55,
"PriceMonthlyChange": -1.3,
"GrossProfitMonthlyChange": 1.8631e+05,
"IndirectCostsMonthlyChange": 1.7395e+05,
"OperatingProfitMonthlyChange": 12364
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Theta 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 69711,
"SalesValue": 4120384,
"Distribution": 99.64,
"CostofSales": 10468,
"Price": 59.11,
"GrossProfit": 4.1099e+06,
"IndirectCosts": 3.8372e+06,
"OperatingProfit": 2.7272e+05,
"UnitSalesMonthlyChange": 52055,
"SalesValueMonthlyChange": 2986989,
"DistributionMonthlyChange": -0.31,
"CostofSalesMonthlyChange": 7588.8,
"PriceMonthlyChange": -5.08,
"GrossProfitMonthlyChange": 2.9794e+06,
"IndirectCostsMonthlyChange": 2.7817e+06,
"OperatingProfitMonthlyChange": 1.977e+05
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "LexCorp",
"Brand": "Gamma",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Gamma 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 2547,
"SalesValue": 158784,
"Distribution": 99.21,
"CostofSales": 403.41,
"Price": 62.34,
"GrossProfit": 1.5838e+05,
"IndirectCosts": 1.4787e+05,
"OperatingProfit": 10510,
"UnitSalesMonthlyChange": 125,
"SalesValueMonthlyChange": 10540,
"DistributionMonthlyChange": 1.29,
"CostofSalesMonthlyChange": 26.78,
"PriceMonthlyChange": 1.13,
"GrossProfitMonthlyChange": 10513,
"IndirectCostsMonthlyChange": 9815.8,
"OperatingProfitMonthlyChange": 697.43
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "MomCorp",
"Brand": "Alpha",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Alpha 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 1537,
"SalesValue": 128728,
"Distribution": 70.09,
"CostofSales": 327.05,
"Price": 83.75,
"GrossProfit": 1.284e+05,
"IndirectCosts": 1.1988e+05,
"OperatingProfit": 8520.6,
"UnitSalesMonthlyChange": 563,
"SalesValueMonthlyChange": 45857,
"DistributionMonthlyChange": -1.67,
"CostofSalesMonthlyChange": 116.51,
"PriceMonthlyChange": -1.33,
"GrossProfitMonthlyChange": 45740,
"IndirectCostsMonthlyChange": 42705,
"OperatingProfitMonthlyChange": 3035.3
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "MomCorp",
"Brand": "Alpha",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Alpha 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 2521,
"SalesValue": 191567,
"Distribution": 95.73,
"CostofSales": 486.7,
"Price": 75.99,
"GrossProfit": 1.9108e+05,
"IndirectCosts": 1.784e+05,
"OperatingProfit": 12679,
"UnitSalesMonthlyChange": 321,
"SalesValueMonthlyChange": 27490,
"DistributionMonthlyChange": 0.41,
"CostofSalesMonthlyChange": 69.84,
"PriceMonthlyChange": 1.41,
"GrossProfitMonthlyChange": 27420,
"IndirectCostsMonthlyChange": 25601,
"OperatingProfitMonthlyChange": 1818.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Beta 8 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 1839,
"SalesValue": 218055,
"Distribution": 97.78,
"CostofSales": 553.99,
"Price": 118.57,
"GrossProfit": 2.175e+05,
"IndirectCosts": 2.0307e+05,
"OperatingProfit": 14433,
"UnitSalesMonthlyChange": 669,
"SalesValueMonthlyChange": 79398,
"DistributionMonthlyChange": 0.37,
"CostofSalesMonthlyChange": 201.72,
"PriceMonthlyChange": 0.06,
"GrossProfitMonthlyChange": 79196,
"IndirectCostsMonthlyChange": 73941,
"OperatingProfitMonthlyChange": 5255.2
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Beta 12 Pack Deluxe",
"PriceTier": "Premium",
"UnitSales": 1241,
"SalesValue": 141427,
"Distribution": 82.09,
"CostofSales": 359.31,
"Price": 113.96,
"GrossProfit": 1.4107e+05,
"IndirectCosts": 1.3171e+05,
"OperatingProfit": 9360.5,
"UnitSalesMonthlyChange": 688,
"SalesValueMonthlyChange": 78391,
"DistributionMonthlyChange": 13.12,
"CostofSalesMonthlyChange": 199.16,
"PriceMonthlyChange": -0.03,
"GrossProfitMonthlyChange": 78192,
"IndirectCostsMonthlyChange": 73004,
"OperatingProfitMonthlyChange": 5188.3
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Beta 12 Pack Giftset",
"PriceTier": "Premium",
"UnitSales": 6796,
"SalesValue": 786737,
"Distribution": 99.43,
"CostofSales": 1998.8,
"Price": 115.76,
"GrossProfit": 7.8474e+05,
"IndirectCosts": 7.3267e+05,
"OperatingProfit": 52072,
"UnitSalesMonthlyChange": 4294,
"SalesValueMonthlyChange": 490375,
"DistributionMonthlyChange": 2.32,
"CostofSalesMonthlyChange": 1245.8,
"PriceMonthlyChange": -2.69,
"GrossProfitMonthlyChange": 4.8913e+05,
"IndirectCostsMonthlyChange": 4.5667e+05,
"OperatingProfitMonthlyChange": 32456
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Beta 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 8007,
"SalesValue": 823151,
"Distribution": 99.93,
"CostofSales": 2091.3,
"Price": 102.8,
"GrossProfit": 8.2106e+05,
"IndirectCosts": 7.6658e+05,
"OperatingProfit": 54483,
"UnitSalesMonthlyChange": 1427,
"SalesValueMonthlyChange": 153240,
"DistributionMonthlyChange": 0.02,
"CostofSalesMonthlyChange": 389.32,
"PriceMonthlyChange": 0.99,
"GrossProfitMonthlyChange": 1.5285e+05,
"IndirectCostsMonthlyChange": 1.4271e+05,
"OperatingProfitMonthlyChange": 10143
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Beta 18 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 17705,
"SalesValue": 1542020,
"Distribution": 98.23,
"CostofSales": 3917.7,
"Price": 87.1,
"GrossProfit": 1.5381e+06,
"IndirectCosts": 1.436e+06,
"OperatingProfit": 1.0206e+05,
"UnitSalesMonthlyChange": 10228,
"SalesValueMonthlyChange": 868979,
"DistributionMonthlyChange": 1.66,
"CostofSalesMonthlyChange": 2207.7,
"PriceMonthlyChange": -2.91,
"GrossProfitMonthlyChange": 8.6677e+05,
"IndirectCostsMonthlyChange": 8.0926e+05,
"OperatingProfitMonthlyChange": 57515
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 60,
"PackType": "Standard",
"SKU": "Beta 60 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 974,
"SalesValue": 103201,
"Distribution": 50.46,
"CostofSales": 262.19,
"Price": 105.96,
"GrossProfit": 1.0294e+05,
"IndirectCosts": 96108,
"OperatingProfit": 6830.4,
"UnitSalesMonthlyChange": 382,
"SalesValueMonthlyChange": 42390,
"DistributionMonthlyChange": 7.98,
"CostofSalesMonthlyChange": 107.7,
"PriceMonthlyChange": 3.24,
"GrossProfitMonthlyChange": 42282,
"IndirectCostsMonthlyChange": 39477,
"OperatingProfitMonthlyChange": 2805.1
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Stark Ind",
"Brand": "Omega",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Omega 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 625,
"SalesValue": 39725,
"Distribution": 36.61,
"CostofSales": 100.93,
"Price": 63.56,
"GrossProfit": 39624,
"IndirectCosts": 36995,
"OperatingProfit": 2629.5,
"UnitSalesMonthlyChange": 245,
"SalesValueMonthlyChange": 15871,
"DistributionMonthlyChange": -1.41,
"CostofSalesMonthlyChange": 40.33,
"PriceMonthlyChange": 0.79,
"GrossProfitMonthlyChange": 15831,
"IndirectCostsMonthlyChange": 14780,
"OperatingProfitMonthlyChange": 1050.3
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Kappa 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 1416,
"SalesValue": 108079,
"Distribution": 64.3,
"CostofSales": 274.58,
"Price": 76.33,
"GrossProfit": 1.078e+05,
"IndirectCosts": 1.0065e+05,
"OperatingProfit": 7153.3,
"UnitSalesMonthlyChange": 425,
"SalesValueMonthlyChange": 32565,
"DistributionMonthlyChange": 0.79,
"CostofSalesMonthlyChange": 82.73,
"PriceMonthlyChange": 0.13,
"GrossProfitMonthlyChange": 32482,
"IndirectCostsMonthlyChange": 30327,
"OperatingProfitMonthlyChange": 2155.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Kappa 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 5180,
"SalesValue": 355197,
"Distribution": 99.33,
"CostofSales": 902.41,
"Price": 68.57,
"GrossProfit": 3.5429e+05,
"IndirectCosts": 3.3078e+05,
"OperatingProfit": 23510,
"UnitSalesMonthlyChange": 2874,
"SalesValueMonthlyChange": 187428,
"DistributionMonthlyChange": 0.59,
"CostofSalesMonthlyChange": 476.18,
"PriceMonthlyChange": -4.18,
"GrossProfitMonthlyChange": 1.8695e+05,
"IndirectCostsMonthlyChange": 1.7455e+05,
"OperatingProfitMonthlyChange": 12405
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Kappa 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 11113,
"SalesValue": 697498,
"Distribution": 99.07,
"CostofSales": 1772.1,
"Price": 62.76,
"GrossProfit": 6.9573e+05,
"IndirectCosts": 6.4956e+05,
"OperatingProfit": 46166,
"UnitSalesMonthlyChange": 1348,
"SalesValueMonthlyChange": 89144,
"DistributionMonthlyChange": 0.71,
"CostofSalesMonthlyChange": 226.47,
"PriceMonthlyChange": 0.46,
"GrossProfitMonthlyChange": 88918,
"IndirectCostsMonthlyChange": 83017,
"OperatingProfitMonthlyChange": 5900.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Hypermarkets",
"Owner": "Wayne Ent",
"Brand": "Pi",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Pi 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 1380,
"SalesValue": 108170,
"Distribution": 74.75,
"CostofSales": 274.82,
"Price": 78.38,
"GrossProfit": 1.079e+05,
"IndirectCosts": 1.0074e+05,
"OperatingProfit": 7159.7,
"UnitSalesMonthlyChange": 622,
"SalesValueMonthlyChange": 48739,
"DistributionMonthlyChange": -3.19,
"CostofSalesMonthlyChange": 123.83,
"PriceMonthlyChange": -0.03,
"GrossProfitMonthlyChange": 48615,
"IndirectCostsMonthlyChange": 45389,
"OperatingProfitMonthlyChange": 3225.7
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Delta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Delta 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 808,
"SalesValue": 48600,
"Distribution": 20.13,
"CostofSales": 123.47,
"Price": 60.15,
"GrossProfit": 48477,
"IndirectCosts": 45260,
"OperatingProfit": 3216.7,
"UnitSalesMonthlyChange": 23,
"SalesValueMonthlyChange": 2091,
"DistributionMonthlyChange": 1.33,
"CostofSalesMonthlyChange": 5.31,
"PriceMonthlyChange": 0.9,
"GrossProfitMonthlyChange": 2085.7,
"IndirectCostsMonthlyChange": 1947.3,
"OperatingProfitMonthlyChange": 138.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Eta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Eta 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 709,
"SalesValue": 31264,
"Distribution": 4.11,
"CostofSales": 79.43,
"Price": 44.1,
"GrossProfit": 31185,
"IndirectCosts": 29115,
"OperatingProfit": 2069.1,
"UnitSalesMonthlyChange": -97,
"SalesValueMonthlyChange": -4289,
"DistributionMonthlyChange": 0,
"CostofSalesMonthlyChange": -10.89,
"PriceMonthlyChange": -0.01,
"GrossProfitMonthlyChange": -4278.1,
"IndirectCostsMonthlyChange": -3994,
"OperatingProfitMonthlyChange": -284.07
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Omicron 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 32105,
"SalesValue": 2204656,
"Distribution": 46.36,
"CostofSales": 5601.2,
"Price": 68.67,
"GrossProfit": 2.1991e+06,
"IndirectCosts": 2.0531e+06,
"OperatingProfit": 1.4592e+05,
"UnitSalesMonthlyChange": -3221,
"SalesValueMonthlyChange": -262911,
"DistributionMonthlyChange": -8.57,
"CostofSalesMonthlyChange": -667.95,
"PriceMonthlyChange": -1.18,
"GrossProfitMonthlyChange": -2.6224e+05,
"IndirectCostsMonthlyChange": -2.4484e+05,
"OperatingProfitMonthlyChange": -17401
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Omicron 12 Pack Deluxe",
"PriceTier": "Regular",
"UnitSales": 519,
"SalesValue": 49345,
"Distribution": 10.91,
"CostofSales": 125.36,
"Price": 95.08,
"GrossProfit": 49220,
"IndirectCosts": 45953,
"OperatingProfit": 3266.4,
"UnitSalesMonthlyChange": 197,
"SalesValueMonthlyChange": 18693,
"DistributionMonthlyChange": 2.35,
"CostofSalesMonthlyChange": 47.49,
"PriceMonthlyChange": -0.11,
"GrossProfitMonthlyChange": 18646,
"IndirectCostsMonthlyChange": 17408,
"OperatingProfitMonthlyChange": 1237.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Omicron 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 6115,
"SalesValue": 532679,
"Distribution": 39.27,
"CostofSales": 1353.3,
"Price": 87.11,
"GrossProfit": 5.3133e+05,
"IndirectCosts": 4.9607e+05,
"OperatingProfit": 35256,
"UnitSalesMonthlyChange": 2461,
"SalesValueMonthlyChange": 212548,
"DistributionMonthlyChange": 2.32,
"CostofSalesMonthlyChange": 540.01,
"PriceMonthlyChange": -0.5,
"GrossProfitMonthlyChange": 2.1201e+05,
"IndirectCostsMonthlyChange": 1.9794e+05,
"OperatingProfitMonthlyChange": 14067
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Omicron 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 5464,
"SalesValue": 400160,
"Distribution": 24.37,
"CostofSales": 1016.6,
"Price": 73.24,
"GrossProfit": 3.9914e+05,
"IndirectCosts": 3.7266e+05,
"OperatingProfit": 26486,
"UnitSalesMonthlyChange": 1235,
"SalesValueMonthlyChange": 84693,
"DistributionMonthlyChange": 0.85,
"CostofSalesMonthlyChange": 215.18,
"PriceMonthlyChange": -1.36,
"GrossProfitMonthlyChange": 84478,
"IndirectCostsMonthlyChange": 78872,
"OperatingProfitMonthlyChange": 5605.6
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Omicron",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Omicron 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 94757,
"SalesValue": 5577970,
"Distribution": 74.64,
"CostofSales": 14171,
"Price": 58.87,
"GrossProfit": 5.5638e+06,
"IndirectCosts": 5.1946e+06,
"OperatingProfit": 3.6919e+05,
"UnitSalesMonthlyChange": 65193,
"SalesValueMonthlyChange": 3795458,
"DistributionMonthlyChange": 33.15,
"CostofSalesMonthlyChange": 9642.8,
"PriceMonthlyChange": -1.42,
"GrossProfitMonthlyChange": 3.7858e+06,
"IndirectCostsMonthlyChange": 3.5346e+06,
"OperatingProfitMonthlyChange": 2.5121e+05
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Sigma",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Sigma 12 Pack Giftset",
"PriceTier": "Premium",
"UnitSales": 593,
"SalesValue": 97327,
"Distribution": 14.33,
"CostofSales": 247.27,
"Price": 164.13,
"GrossProfit": 97080,
"IndirectCosts": 90638,
"OperatingProfit": 6441.6,
"UnitSalesMonthlyChange": 330,
"SalesValueMonthlyChange": 51824,
"DistributionMonthlyChange": 2.08,
"CostofSalesMonthlyChange": 131.67,
"PriceMonthlyChange": -8.89,
"GrossProfitMonthlyChange": 51692,
"IndirectCostsMonthlyChange": 48263,
"OperatingProfitMonthlyChange": 3429.7
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Sigma",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Sigma 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 1664,
"SalesValue": 246175,
"Distribution": 27.86,
"CostofSales": 625.43,
"Price": 147.94,
"GrossProfit": 2.4555e+05,
"IndirectCosts": 2.2926e+05,
"OperatingProfit": 16294,
"UnitSalesMonthlyChange": 550,
"SalesValueMonthlyChange": 76112,
"DistributionMonthlyChange": 1.26,
"CostofSalesMonthlyChange": 193.37,
"PriceMonthlyChange": -4.72,
"GrossProfitMonthlyChange": 75919,
"IndirectCostsMonthlyChange": 70881,
"OperatingProfitMonthlyChange": 5037.9
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Aperture",
"Brand": "Tau",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Tau 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 365,
"SalesValue": 29458,
"Distribution": 13.18,
"CostofSales": 74.84,
"Price": 80.71,
"GrossProfit": 29383,
"IndirectCosts": 27433,
"OperatingProfit": 1950.1,
"UnitSalesMonthlyChange": 54,
"SalesValueMonthlyChange": 4313,
"DistributionMonthlyChange": 0.02,
"CostofSalesMonthlyChange": 10.96,
"PriceMonthlyChange": -0.14,
"GrossProfitMonthlyChange": 4302,
"IndirectCostsMonthlyChange": 4015.8,
"OperatingProfitMonthlyChange": 286.21
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Epsilon",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Epsilon 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 557,
"SalesValue": 30431,
"Distribution": 6.77,
"CostofSales": 77.32,
"Price": 54.63,
"GrossProfit": 30354,
"IndirectCosts": 28340,
"OperatingProfit": 2013.8,
"UnitSalesMonthlyChange": 37,
"SalesValueMonthlyChange": 2278,
"DistributionMonthlyChange": 1.51,
"CostofSalesMonthlyChange": 5.79,
"PriceMonthlyChange": 0.49,
"GrossProfitMonthlyChange": 2272.2,
"IndirectCostsMonthlyChange": 2121.6,
"OperatingProfitMonthlyChange": 150.59
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Iota",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Iota 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 505,
"SalesValue": 50380,
"Distribution": 14,
"CostofSales": 127.99,
"Price": 99.76,
"GrossProfit": 50252,
"IndirectCosts": 46917,
"OperatingProfit": 3334.9,
"UnitSalesMonthlyChange": 193,
"SalesValueMonthlyChange": 19161,
"DistributionMonthlyChange": 0.96,
"CostofSalesMonthlyChange": 48.68,
"PriceMonthlyChange": -0.3,
"GrossProfitMonthlyChange": 19112,
"IndirectCostsMonthlyChange": 17844,
"OperatingProfitMonthlyChange": 1268.2
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Iota",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Iota 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 1458,
"SalesValue": 134738,
"Distribution": 30.3,
"CostofSales": 342.32,
"Price": 92.41,
"GrossProfit": 1.344e+05,
"IndirectCosts": 1.2548e+05,
"OperatingProfit": 8917.6,
"UnitSalesMonthlyChange": 358,
"SalesValueMonthlyChange": 32658,
"DistributionMonthlyChange": 1.1,
"CostofSalesMonthlyChange": 82.98,
"PriceMonthlyChange": -0.39,
"GrossProfitMonthlyChange": 32575,
"IndirectCostsMonthlyChange": 30413,
"OperatingProfitMonthlyChange": 2161.6
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Lambda",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Lambda 8 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 946,
"SalesValue": 60466,
"Distribution": 18.45,
"CostofSales": 153.62,
"Price": 63.92,
"GrossProfit": 60312,
"IndirectCosts": 56310,
"OperatingProfit": 4001.9,
"UnitSalesMonthlyChange": -325,
"SalesValueMonthlyChange": -19276,
"DistributionMonthlyChange": 2.07,
"CostofSalesMonthlyChange": -48.97,
"PriceMonthlyChange": 1.18,
"GrossProfitMonthlyChange": -19227,
"IndirectCostsMonthlyChange": -17951,
"OperatingProfitMonthlyChange": -1276.2
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Lambda",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Lambda 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 3500,
"SalesValue": 204598,
"Distribution": 32.45,
"CostofSales": 519.8,
"Price": 58.46,
"GrossProfit": 2.0408e+05,
"IndirectCosts": 1.9054e+05,
"OperatingProfit": 13542,
"UnitSalesMonthlyChange": 562,
"SalesValueMonthlyChange": 32422,
"DistributionMonthlyChange": -0.42,
"CostofSalesMonthlyChange": 82.37,
"PriceMonthlyChange": -0.14,
"GrossProfitMonthlyChange": 32340,
"IndirectCostsMonthlyChange": 30194,
"OperatingProfitMonthlyChange": 2145.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Mu",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Mu 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 946,
"SalesValue": 151789,
"Distribution": 20.94,
"CostofSales": 385.63,
"Price": 160.45,
"GrossProfit": 1.514e+05,
"IndirectCosts": 1.4136e+05,
"OperatingProfit": 10047,
"UnitSalesMonthlyChange": 269,
"SalesValueMonthlyChange": 39981,
"DistributionMonthlyChange": 2.07,
"CostofSalesMonthlyChange": 101.57,
"PriceMonthlyChange": -4.7,
"GrossProfitMonthlyChange": 39879,
"IndirectCostsMonthlyChange": 37233,
"OperatingProfitMonthlyChange": 2646.2
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 6,
"PackType": "Standard",
"SKU": "Theta 6 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 319,
"SalesValue": 32937,
"Distribution": 6.87,
"CostofSales": 83.68,
"Price": 103.25,
"GrossProfit": 32853,
"IndirectCosts": 30673,
"OperatingProfit": 2180,
"UnitSalesMonthlyChange": 80,
"SalesValueMonthlyChange": 8117,
"DistributionMonthlyChange": 0.62,
"CostofSalesMonthlyChange": 20.62,
"PriceMonthlyChange": -0.6,
"GrossProfitMonthlyChange": 8096.4,
"IndirectCostsMonthlyChange": 7558.9,
"OperatingProfitMonthlyChange": 537.43
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Theta 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 2681,
"SalesValue": 220090,
"Distribution": 27.09,
"CostofSales": 559.16,
"Price": 82.09,
"GrossProfit": 2.1953e+05,
"IndirectCosts": 2.0496e+05,
"OperatingProfit": 14567,
"UnitSalesMonthlyChange": 216,
"SalesValueMonthlyChange": 11658,
"DistributionMonthlyChange": -0.1,
"CostofSalesMonthlyChange": 29.62,
"PriceMonthlyChange": -2.47,
"GrossProfitMonthlyChange": 11628,
"IndirectCostsMonthlyChange": 10857,
"OperatingProfitMonthlyChange": 771.05
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Theta 12 Pack Deluxe",
"PriceTier": "Regular",
"UnitSales": 3882,
"SalesValue": 284110,
"Distribution": 22.21,
"CostofSales": 721.81,
"Price": 73.19,
"GrossProfit": 2.8339e+05,
"IndirectCosts": 2.6458e+05,
"OperatingProfit": 18805,
"UnitSalesMonthlyChange": 3740,
"SalesValueMonthlyChange": 271017,
"DistributionMonthlyChange": 15.2,
"CostofSalesMonthlyChange": 688.55,
"PriceMonthlyChange": -19.01,
"GrossProfitMonthlyChange": 2.7033e+05,
"IndirectCostsMonthlyChange": 2.5239e+05,
"OperatingProfitMonthlyChange": 17939
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Theta 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 2506,
"SalesValue": 233914,
"Distribution": 22.78,
"CostofSales": 594.28,
"Price": 93.34,
"GrossProfit": 2.3332e+05,
"IndirectCosts": 2.1784e+05,
"OperatingProfit": 15483,
"UnitSalesMonthlyChange": 912,
"SalesValueMonthlyChange": 81999,
"DistributionMonthlyChange": 0.09,
"CostofSalesMonthlyChange": 208.32,
"PriceMonthlyChange": -1.96,
"GrossProfitMonthlyChange": 81791,
"IndirectCostsMonthlyChange": 76363,
"OperatingProfitMonthlyChange": 5427.3
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Theta 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 11830,
"SalesValue": 901034,
"Distribution": 47.5,
"CostofSales": 2289.2,
"Price": 76.17,
"GrossProfit": 8.9874e+05,
"IndirectCosts": 8.3911e+05,
"OperatingProfit": 59637,
"UnitSalesMonthlyChange": 1423,
"SalesValueMonthlyChange": 101989,
"DistributionMonthlyChange": 2.05,
"CostofSalesMonthlyChange": 259.11,
"PriceMonthlyChange": -0.61,
"GrossProfitMonthlyChange": 1.0173e+05,
"IndirectCostsMonthlyChange": 94979,
"OperatingProfitMonthlyChange": 6750.8
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Black Mesa",
"Brand": "Theta",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Theta 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 68455,
"SalesValue": 3896305,
"Distribution": 47.08,
"CostofSales": 9899,
"Price": 56.92,
"GrossProfit": 3.8864e+06,
"IndirectCosts": 3.6285e+06,
"OperatingProfit": 2.5789e+05,
"UnitSalesMonthlyChange": 55770,
"SalesValueMonthlyChange": 3049397,
"DistributionMonthlyChange": 6.91,
"CostofSalesMonthlyChange": 7747.3,
"PriceMonthlyChange": -9.84,
"GrossProfitMonthlyChange": 3.0416e+06,
"IndirectCostsMonthlyChange": 2.8398e+06,
"OperatingProfitMonthlyChange": 2.0183e+05
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "LexCorp",
"Brand": "Gamma",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Gamma 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 805,
"SalesValue": 57791,
"Distribution": 20.86,
"CostofSales": 146.83,
"Price": 71.79,
"GrossProfit": 57644,
"IndirectCosts": 53819,
"OperatingProfit": 3825.2,
"UnitSalesMonthlyChange": -168,
"SalesValueMonthlyChange": -10522,
"DistributionMonthlyChange": -1.38,
"CostofSalesMonthlyChange": -26.73,
"PriceMonthlyChange": 1.58,
"GrossProfitMonthlyChange": -10495,
"IndirectCostsMonthlyChange": -9799,
"OperatingProfitMonthlyChange": -696.24
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "MomCorp",
"Brand": "Alpha",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Alpha 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 4026,
"SalesValue": 307918,
"Distribution": 35.98,
"CostofSales": 782.3,
"Price": 76.48,
"GrossProfit": 3.0714e+05,
"IndirectCosts": 2.8676e+05,
"OperatingProfit": 20380,
"UnitSalesMonthlyChange": 3092,
"SalesValueMonthlyChange": 220954,
"DistributionMonthlyChange": 16.21,
"CostofSalesMonthlyChange": 561.36,
"PriceMonthlyChange": -16.63,
"GrossProfitMonthlyChange": 2.2039e+05,
"IndirectCostsMonthlyChange": 2.0577e+05,
"OperatingProfitMonthlyChange": 14624
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "MomCorp",
"Brand": "Alpha",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Alpha 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 260,
"SalesValue": 22211,
"Distribution": 7.63,
"CostofSales": 56.43,
"Price": 85.43,
"GrossProfit": 22155,
"IndirectCosts": 20684,
"OperatingProfit": 1470.3,
"UnitSalesMonthlyChange": -41,
"SalesValueMonthlyChange": -2797,
"DistributionMonthlyChange": -1.23,
"CostofSalesMonthlyChange": -7.1,
"PriceMonthlyChange": 2.35,
"GrossProfitMonthlyChange": -2789.9,
"IndirectCostsMonthlyChange": -2605,
"OperatingProfitMonthlyChange": -184.94
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Beta 8 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 1310,
"SalesValue": 159261,
"Distribution": 16.47,
"CostofSales": 404.62,
"Price": 121.57,
"GrossProfit": 1.5886e+05,
"IndirectCosts": 1.4832e+05,
"OperatingProfit": 10541,
"UnitSalesMonthlyChange": 70,
"SalesValueMonthlyChange": 6737,
"DistributionMonthlyChange": 0.63,
"CostofSalesMonthlyChange": 17.12,
"PriceMonthlyChange": -1.43,
"GrossProfitMonthlyChange": 6719.9,
"IndirectCostsMonthlyChange": 6274.4,
"OperatingProfitMonthlyChange": 445.53
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Deluxe",
"SKU": "Beta 12 Pack Deluxe",
"PriceTier": "Premium",
"UnitSales": 413,
"SalesValue": 53091,
"Distribution": 8.57,
"CostofSales": 134.89,
"Price": 128.55,
"GrossProfit": 52956,
"IndirectCosts": 49442,
"OperatingProfit": 3514,
"UnitSalesMonthlyChange": 276,
"SalesValueMonthlyChange": 36152,
"DistributionMonthlyChange": 4.26,
"CostofSalesMonthlyChange": 91.86,
"PriceMonthlyChange": 4.91,
"GrossProfitMonthlyChange": 36060,
"IndirectCostsMonthlyChange": 33668,
"OperatingProfitMonthlyChange": 2392.4
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Beta 12 Pack Giftset",
"PriceTier": "Premium",
"UnitSales": 2917,
"SalesValue": 365333,
"Distribution": 24.44,
"CostofSales": 928.17,
"Price": 125.24,
"GrossProfit": 3.644e+05,
"IndirectCosts": 3.4022e+05,
"OperatingProfit": 24180,
"UnitSalesMonthlyChange": 1319,
"SalesValueMonthlyChange": 163449,
"DistributionMonthlyChange": 2.27,
"CostofSalesMonthlyChange": 415.27,
"PriceMonthlyChange": -1.1,
"GrossProfitMonthlyChange": 1.6303e+05,
"IndirectCostsMonthlyChange": 1.5222e+05,
"OperatingProfitMonthlyChange": 10818
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Beta 12 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 9691,
"SalesValue": 1033889,
"Distribution": 39.22,
"CostofSales": 2626.7,
"Price": 106.69,
"GrossProfit": 1.0313e+06,
"IndirectCosts": 9.6283e+05,
"OperatingProfit": 68431,
"UnitSalesMonthlyChange": 1705,
"SalesValueMonthlyChange": 194790,
"DistributionMonthlyChange": -1.5,
"CostofSalesMonthlyChange": 494.88,
"PriceMonthlyChange": 1.62,
"GrossProfitMonthlyChange": 1.943e+05,
"IndirectCostsMonthlyChange": 1.814e+05,
"OperatingProfitMonthlyChange": 12893
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Beta 18 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 8422,
"SalesValue": 776210,
"Distribution": 33.89,
"CostofSales": 1972,
"Price": 92.16,
"GrossProfit": 7.7424e+05,
"IndirectCosts": 7.2286e+05,
"OperatingProfit": 51376,
"UnitSalesMonthlyChange": 5184,
"SalesValueMonthlyChange": 445398,
"DistributionMonthlyChange": 8.63,
"CostofSalesMonthlyChange": 1131.6,
"PriceMonthlyChange": -10.01,
"GrossProfitMonthlyChange": 4.4427e+05,
"IndirectCostsMonthlyChange": 4.1479e+05,
"OperatingProfitMonthlyChange": 29480
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Rekall",
"Brand": "Beta",
"PackSize": 60,
"PackType": "Standard",
"SKU": "Beta 60 Pack Standard",
"PriceTier": "Premium",
"UnitSales": 223,
"SalesValue": 28738,
"Distribution": 4.02,
"CostofSales": 73.01,
"Price": 128.87,
"GrossProfit": 28665,
"IndirectCosts": 26763,
"OperatingProfit": 1902.5,
"UnitSalesMonthlyChange": 24,
"SalesValueMonthlyChange": 3161,
"DistributionMonthlyChange": 1.43,
"CostofSalesMonthlyChange": 8.03,
"PriceMonthlyChange": 0.34,
"GrossProfitMonthlyChange": 3153,
"IndirectCostsMonthlyChange": 2943.6,
"OperatingProfitMonthlyChange": 209.41
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Stark Ind",
"Brand": "Omega",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Omega 12 Pack Standard",
"PriceTier": "Budget",
"UnitSales": 748,
"SalesValue": 48223,
"Distribution": 13.49,
"CostofSales": 122.51,
"Price": 64.47,
"GrossProfit": 48100,
"IndirectCosts": 44908,
"OperatingProfit": 3192.1,
"UnitSalesMonthlyChange": -137,
"SalesValueMonthlyChange": -7190,
"DistributionMonthlyChange": -5.55,
"CostofSalesMonthlyChange": -18.27,
"PriceMonthlyChange": 1.86,
"GrossProfitMonthlyChange": -7171.7,
"IndirectCostsMonthlyChange": -6696.2,
"OperatingProfitMonthlyChange": -475.51
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 8,
"PackType": "Standard",
"SKU": "Kappa 8 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 11263,
"SalesValue": 703847,
"Distribution": 36.56,
"CostofSales": 1788.2,
"Price": 62.49,
"GrossProfit": 7.0206e+05,
"IndirectCosts": 6.5547e+05,
"OperatingProfit": 46586,
"UnitSalesMonthlyChange": -10565,
"SalesValueMonthlyChange": -625137,
"DistributionMonthlyChange": 1.02,
"CostofSalesMonthlyChange": -1588.2,
"PriceMonthlyChange": 1.61,
"GrossProfitMonthlyChange": -6.2355e+05,
"IndirectCostsMonthlyChange": -5.8217e+05,
"OperatingProfitMonthlyChange": -41377
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 12,
"PackType": "Standard",
"SKU": "Kappa 12 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 4999,
"SalesValue": 377208,
"Distribution": 39,
"CostofSales": 958.34,
"Price": 75.46,
"GrossProfit": 3.7625e+05,
"IndirectCosts": 3.5128e+05,
"OperatingProfit": 24966,
"UnitSalesMonthlyChange": 1864,
"SalesValueMonthlyChange": 128842,
"DistributionMonthlyChange": 4.93,
"CostofSalesMonthlyChange": 327.34,
"PriceMonthlyChange": -3.76,
"GrossProfitMonthlyChange": 1.2851e+05,
"IndirectCostsMonthlyChange": 1.1999e+05,
"OperatingProfitMonthlyChange": 8528.1
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Tyrell Corp",
"Brand": "Kappa",
"PackSize": 18,
"PackType": "Standard",
"SKU": "Kappa 18 Pack Standard",
"PriceTier": "Regular",
"UnitSales": 5330,
"SalesValue": 339454,
"Distribution": 31.78,
"CostofSales": 862.42,
"Price": 63.69,
"GrossProfit": 3.3859e+05,
"IndirectCosts": 3.1612e+05,
"OperatingProfit": 22467,
"UnitSalesMonthlyChange": -1763,
"SalesValueMonthlyChange": -103005,
"DistributionMonthlyChange": -0.35,
"CostofSalesMonthlyChange": -261.69,
"PriceMonthlyChange": 1.31,
"GrossProfitMonthlyChange": -1.0274e+05,
"IndirectCostsMonthlyChange": -95926,
"OperatingProfitMonthlyChange": -6817.7
},
{
"Date": "01/12/2012",
"Month": "Dec-12",
"Channel": "Supermarkets",
"Owner": "Wayne Ent",
"Brand": "Pi",
"PackSize": 12,
"PackType": "Giftset",
"SKU": "Pi 12 Pack Giftset",
"PriceTier": "Regular",
"UnitSales": 176,
"SalesValue": 14269,
"Distribution": 5.97,
"CostofSales": 36.25,
"Price": 81.07,
"GrossProfit": 14233,
"IndirectCosts": 13289,
"OperatingProfit": 944.24,
"UnitSalesMonthlyChange": 4,
"SalesValueMonthlyChange": -3,
"DistributionMonthlyChange": 0.12,
"CostofSalesMonthlyChange": -0.01,
"PriceMonthlyChange": -1.91,
"GrossProfitMonthlyChange": -2.99,
"IndirectCostsMonthlyChange": -2.79,
"OperatingProfitMonthlyChange": -0.2
}
],
xAxis = {
"type": "addMeasureAxis",
"showPercent": false
},
yAxis = {
"type": "addMeasureAxis",
"showPercent": false
},
zAxis = [],
colorAxis = [],
legend = {
"x": 530,
"y": 100,
"width": 60,
"height": 300,
"horizontalAlign": "right"
};
var svg = dimple.newSvg("#" + opts.id, opts.width, opts.height);
//data = dimple.filterData(data, "Owner", ["Aperture", "Black Mesa"])
var myChart = new dimple.chart(svg, data);
if (opts.bounds) {
myChart.setBounds(opts.bounds.x, opts.bounds.y, opts.bounds.width, opts.bounds.height);//myChart.setBounds(80, 30, 480, 330);
}
//dimple allows use of custom CSS with noFormats
if(opts.noFormats) { myChart.noFormats = opts.noFormats; };
//for markimekko and addAxis also have third parameter measure
//so need to evaluate if measure provided
//x axis
var x;
if(xAxis.measure) {
x = myChart[xAxis.type]("x",opts.x,xAxis.measure);
} else {
x = myChart[xAxis.type]("x", opts.x);
};
if(!(xAxis.type === "addPctAxis")) x.showPercent = xAxis.showPercent;
if (xAxis.orderRule) x.addOrderRule(xAxis.orderRule);
if (xAxis.grouporderRule) x.addGroupOrderRule(xAxis.grouporderRule);
if (xAxis.overrideMin) x.overrideMin = xAxis.overrideMin;
if (xAxis.overrideMax) x.overrideMax = xAxis.overrideMax;
if (xAxis.overrideMax) x.overrideMax = xAxis.overrideMax;
if (xAxis.inputFormat) x.dateParseFormat = xAxis.inputFormat;
if (xAxis.outputFormat) x.tickFormat = xAxis.outputFormat;
//y axis
var y;
if(yAxis.measure) {
y = myChart[yAxis.type]("y",opts.y,yAxis.measure);
} else {
y = myChart[yAxis.type]("y", opts.y);
};
if(!(yAxis.type === "addPctAxis")) y.showPercent = yAxis.showPercent;
if (yAxis.orderRule) y.addOrderRule(yAxis.orderRule);
if (yAxis.grouporderRule) y.addGroupOrderRule(yAxis.grouporderRule);
if (yAxis.overrideMin) y.overrideMin = yAxis.overrideMin;
if (yAxis.overrideMax) y.overrideMax = yAxis.overrideMax;
if (yAxis.inputFormat) y.dateParseFormat = yAxis.inputFormat;
if (yAxis.outputFormat) y.tickFormat = yAxis.outputFormat;
//z for bubbles
var z;
if (!(typeof(zAxis) === 'undefined') && zAxis.type){
if(zAxis.measure) {
z = myChart[zAxis.type]("z",opts.z,zAxis.measure);
} else {
z = myChart[zAxis.type]("z", opts.z);
};
if(!(zAxis.type === "addPctAxis")) z.showPercent = zAxis.showPercent;
if (zAxis.orderRule) z.addOrderRule(zAxis.orderRule);
if (zAxis.overrideMin) z.overrideMin = zAxis.overrideMin;
if (zAxis.overrideMax) z.overrideMax = zAxis.overrideMax;
}
if(d3.keys(colorAxis).length > 0) {
myChart[colorAxis.type](colorAxis.colorSeries,colorAxis.palette) ;
}
//here need think I need to evaluate group and if missing do null
//as the first argument
//if provided need to use groups from opts
if(opts.hasOwnProperty("groups")) {
var s = myChart.addSeries( opts.groups, dimple.plot[opts.type] );
//series offers an aggregate method that we will also need to check if available
//options available are avg, count, max, min, sum
if (!(typeof(opts.aggregate) === 'undefined')) {
s.aggregate = eval(opts.aggregate);
}
if (!(typeof(opts.lineWeight) === 'undefined')) {
s.lineWeight = eval(opts.lineWeight);
}
if (!(typeof(opts.barGap) === 'undefined')) {
s.barGap = eval(opts.barGap);
}
} else var s = myChart.addSeries( null, dimple.plot[opts.type] );
//unsure if this is best but if legend is provided (not empty) then evaluate
if(d3.keys(legend).length > 0) {
var l =myChart.addLegend();
d3.keys(legend).forEach(function(d){
l[d] = legend[d];
});
}
//quick way to get this going but need to make this cleaner
if(opts.storyboard) {
myChart.setStoryboard(opts.storyboard);
};
myChart.draw();
</script>
</body>
</html>
Raw
index.html
<!DOCTYPE html>
<!-- saved from url=(0014)about:internet -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Dimple with Knitr</title>
<style type="text/css">
body, td {
font-family: sans-serif;
background-color: white;
font-size: 12px;
margin: 8px;
}
tt, code, pre {
font-family: 'DejaVu Sans Mono', 'Droid Sans Mono', 'Lucida Console', Consolas, Monaco, monospace;
}
h1 {
font-size:2.2em;
}
h2 {
font-size:1.8em;
}
h3 {
font-size:1.4em;
}
h4 {
font-size:1.0em;
}
h5 {
font-size:0.9em;
}
h6 {
font-size:0.8em;
}
a:visited {
color: rgb(50%, 0%, 50%);
}
pre {
margin-top: 0;
max-width: 95%;
border: 1px solid #ccc;
white-space: pre-wrap;
}
pre code {
display: block; padding: 0.5em;
}
code.r, code.cpp {
background-color: #F8F8F8;
}
table, td, th {
border: none;
}
blockquote {
color:#666666;
margin:0;
padding-left: 1em;
border-left: 0.5em #EEE solid;
}
hr {
height: 0px;
border-bottom: none;
border-top-width: thin;
border-top-style: dotted;
border-top-color: #999999;
}
@media print {
* {
background: transparent !important;
color: black !important;
filter:none !important;
-ms-filter: none !important;
}
body {
font-size:12pt;
max-width:100%;
}
a, a:visited {
text-decoration: underline;
}
hr {
visibility: hidden;
page-break-before: always;
}
pre, blockquote {
padding-right: 1em;
page-break-inside: avoid;
}
tr, img {
page-break-inside: avoid;
}
img {
max-width: 100% !important;
}
@page :left {
margin: 15mm 20mm 15mm 10mm;
}
@page :right {
margin: 15mm 10mm 15mm 20mm;
}
p, h2, h3 {
orphans: 3; widows: 3;
}
h2, h3 {
page-break-after: avoid;
}
}
</style>
<!-- Styles for R syntax highlighter -->
<style type="text/css">
pre .operator,
pre .paren {
color: rgb(104, 118, 135)
}
pre .literal {
color: rgb(88, 72, 246)
}
pre .number {
color: rgb(0, 0, 205);
}
pre .comment {
color: rgb(76, 136, 107);
}
pre .keyword {
color: rgb(0, 0, 255);
}
pre .identifier {
color: rgb(0, 0, 0);
}
pre .string {
color: rgb(3, 106, 7);
}
</style>
<!-- R syntax highlighter -->
<script type="text/javascript">
var hljs=new function(){function m(p){return p.replace(/&/gm,"&amp;").replace(/</gm,"&lt;")}function f(r,q,p){return RegExp(q,"m"+(r.cI?"i":"")+(p?"g":""))}function b(r){for(var p=0;p<r.childNodes.length;p++){var q=r.childNodes[p];if(q.nodeName=="CODE"){return q}if(!(q.nodeType==3&&q.nodeValue.match(/\s+/))){break}}}function h(t,s){var p="";for(var r=0;r<t.childNodes.length;r++){if(t.childNodes[r].nodeType==3){var q=t.childNodes[r].nodeValue;if(s){q=q.replace(/\n/g,"")}p+=q}else{if(t.childNodes[r].nodeName=="BR"){p+="\n"}else{p+=h(t.childNodes[r])}}}if(/MSIE [678]/.test(navigator.userAgent)){p=p.replace(/\r/g,"\n")}return p}function a(s){var r=s.className.split(/\s+/);r=r.concat(s.parentNode.className.split(/\s+/));for(var q=0;q<r.length;q++){var p=r[q].replace(/^language-/,"");if(e[p]){return p}}}function c(q){var p=[];(function(s,t){for(var r=0;r<s.childNodes.length;r++){if(s.childNodes[r].nodeType==3){t+=s.childNodes[r].nodeValue.length}else{if(s.childNodes[r].nodeName=="BR"){t+=1}else{if(s.childNodes[r].nodeType==1){p.push({event:"start",offset:t,node:s.childNodes[r]});t=arguments.callee(s.childNodes[r],t);p.push({event:"stop",offset:t,node:s.childNodes[r]})}}}}return t})(q,0);return p}function k(y,w,x){var q=0;var z="";var s=[];function u(){if(y.length&&w.length){if(y[0].offset!=w[0].offset){return(y[0].offset<w[0].offset)?y:w}else{return w[0].event=="start"?y:w}}else{return y.length?y:w}}function t(D){var A="<"+D.nodeName.toLowerCase();for(var B=0;B<D.attributes.length;B++){var C=D.attributes[B];A+=" "+C.nodeName.toLowerCase();if(C.value!==undefined&&C.value!==false&&C.value!==null){A+='="'+m(C.value)+'"'}}return A+">"}while(y.length||w.length){var v=u().splice(0,1)[0];z+=m(x.substr(q,v.offset-q));q=v.offset;if(v.event=="start"){z+=t(v.node);s.push(v.node)}else{if(v.event=="stop"){var p,r=s.length;do{r--;p=s[r];z+=("</"+p.nodeName.toLowerCase()+">")}while(p!=v.node);s.splice(r,1);while(r<s.length){z+=t(s[r]);r++}}}}return z+m(x.substr(q))}function j(){function q(x,y,v){if(x.compiled){return}var u;var s=[];if(x.k){x.lR=f(y,x.l||hljs.IR,true);for(var w in x.k){if(!x.k.hasOwnProperty(w)){continue}if(x.k[w] instanceof Object){u=x.k[w]}else{u=x.k;w="keyword"}for(var r in u){if(!u.hasOwnProperty(r)){continue}x.k[r]=[w,u[r]];s.push(r)}}}if(!v){if(x.bWK){x.b="\\b("+s.join("|")+")\\s"}x.bR=f(y,x.b?x.b:"\\B|\\b");if(!x.e&&!x.eW){x.e="\\B|\\b"}if(x.e){x.eR=f(y,x.e)}}if(x.i){x.iR=f(y,x.i)}if(x.r===undefined){x.r=1}if(!x.c){x.c=[]}x.compiled=true;for(var t=0;t<x.c.length;t++){if(x.c[t]=="self"){x.c[t]=x}q(x.c[t],y,false)}if(x.starts){q(x.starts,y,false)}}for(var p in e){if(!e.hasOwnProperty(p)){continue}q(e[p].dM,e[p],true)}}function d(B,C){if(!j.called){j();j.called=true}function q(r,M){for(var L=0;L<M.c.length;L++){if((M.c[L].bR.exec(r)||[null])[0]==r){return M.c[L]}}}function v(L,r){if(D[L].e&&D[L].eR.test(r)){return 1}if(D[L].eW){var M=v(L-1,r);return M?M+1:0}return 0}function w(r,L){return L.i&&L.iR.test(r)}function K(N,O){var M=[];for(var L=0;L<N.c.length;L++){M.push(N.c[L].b)}var r=D.length-1;do{if(D[r].e){M.push(D[r].e)}r--}while(D[r+1].eW);if(N.i){M.push(N.i)}return f(O,M.join("|"),true)}function p(M,L){var N=D[D.length-1];if(!N.t){N.t=K(N,E)}N.t.lastIndex=L;var r=N.t.exec(M);return r?[M.substr(L,r.index-L),r[0],false]:[M.substr(L),"",true]}function z(N,r){var L=E.cI?r[0].toLowerCase():r[0];var M=N.k[L];if(M&&M instanceof Array){return M}return false}function F(L,P){L=m(L);if(!P.k){return L}var r="";var O=0;P.lR.lastIndex=0;var M=P.lR.exec(L);while(M){r+=L.substr(O,M.index-O);var N=z(P,M);if(N){x+=N[1];r+='<span class="'+N[0]+'">'+M[0]+"</span>"}else{r+=M[0]}O=P.lR.lastIndex;M=P.lR.exec(L)}return r+L.substr(O,L.length-O)}function J(L,M){if(M.sL&&e[M.sL]){var r=d(M.sL,L);x+=r.keyword_count;return r.value}else{return F(L,M)}}function I(M,r){var L=M.cN?'<span class="'+M.cN+'">':"";if(M.rB){y+=L;M.buffer=""}else{if(M.eB){y+=m(r)+L;M.buffer=""}else{y+=L;M.buffer=r}}D.push(M);A+=M.r}function G(N,M,Q){var R=D[D.length-1];if(Q){y+=J(R.buffer+N,R);return false}var P=q(M,R);if(P){y+=J(R.buffer+N,R);I(P,M);return P.rB}var L=v(D.length-1,M);if(L){var O=R.cN?"</span>":"";if(R.rE){y+=J(R.buffer+N,R)+O}else{if(R.eE){y+=J(R.buffer+N,R)+O+m(M)}else{y+=J(R.buffer+N+M,R)+O}}while(L>1){O=D[D.length-2].cN?"</span>":"";y+=O;L--;D.length--}var r=D[D.length-1];D.length--;D[D.length-1].buffer="";if(r.starts){I(r.starts,"")}return R.rE}if(w(M,R)){throw"Illegal"}}var E=e[B];var D=[E.dM];var A=0;var x=0;var y="";try{var s,u=0;E.dM.buffer="";do{s=p(C,u);var t=G(s[0],s[1],s[2]);u+=s[0].length;if(!t){u+=s[1].length}}while(!s[2]);if(D.length>1){throw"Illegal"}return{r:A,keyword_count:x,value:y}}catch(H){if(H=="Illegal"){return{r:0,keyword_count:0,value:m(C)}}else{throw H}}}function g(t){var p={keyword_count:0,r:0,value:m(t)};var r=p;for(var q in e){if(!e.hasOwnProperty(q)){continue}var s=d(q,t);s.language=q;if(s.keyword_count+s.r>r.keyword_count+r.r){r=s}if(s.keyword_count+s.r>p.keyword_count+p.r){r=p;p=s}}if(r.language){p.second_best=r}return p}function i(r,q,p){if(q){r=r.replace(/^((<[^>]+>|\t)+)/gm,function(t,w,v,u){return w.replace(/\t/g,q)})}if(p){r=r.replace(/\n/g,"<br>")}return r}function n(t,w,r){var x=h(t,r);var v=a(t);var y,s;if(v){y=d(v,x)}else{return}var q=c(t);if(q.length){s=document.createElement("pre");s.innerHTML=y.value;y.value=k(q,c(s),x)}y.value=i(y.value,w,r);var u=t.className;if(!u.match("(\\s|^)(language-)?"+v+"(\\s|$)")){u=u?(u+" "+v):v}if(/MSIE [678]/.test(navigator.userAgent)&&t.tagName=="CODE"&&t.parentNode.tagName=="PRE"){s=t.parentNode;var p=document.createElement("div");p.innerHTML="<pre><code>"+y.value+"</code></pre>";t=p.firstChild.firstChild;p.firstChild.cN=s.cN;s.parentNode.replaceChild(p.firstChild,s)}else{t.innerHTML=y.value}t.className=u;t.result={language:v,kw:y.keyword_count,re:y.r};if(y.second_best){t.second_best={language:y.second_best.language,kw:y.second_best.keyword_count,re:y.second_best.r}}}function o(){if(o.called){return}o.called=true;var r=document.getElementsByTagName("pre");for(var p=0;p<r.length;p++){var q=b(r[p]);if(q){n(q,hljs.tabReplace)}}}function l(){if(window.addEventListener){window.addEventListener("DOMContentLoaded",o,false);window.addEventListener("load",o,false)}else{if(window.attachEvent){window.attachEvent("onload",o)}else{window.onload=o}}}var e={};this.LANGUAGES=e;this.highlight=d;this.highlightAuto=g;this.fixMarkup=i;this.highlightBlock=n;this.initHighlighting=o;this.initHighlightingOnLoad=l;this.IR="[a-zA-Z][a-zA-Z0-9_]*";this.UIR="[a-zA-Z_][a-zA-Z0-9_]*";this.NR="\\b\\d+(\\.\\d+)?";this.CNR="\\b(0[xX][a-fA-F0-9]+|(\\d+(\\.\\d*)?|\\.\\d+)([eE][-+]?\\d+)?)";this.BNR="\\b(0b[01]+)";this.RSR="!|!=|!==|%|%=|&|&&|&=|\\*|\\*=|\\+|\\+=|,|\\.|-|-=|/|/=|:|;|<|<<|<<=|<=|=|==|===|>|>=|>>|>>=|>>>|>>>=|\\?|\\[|\\{|\\(|\\^|\\^=|\\||\\|=|\\|\\||~";this.ER="(?![\\s\\S])";this.BE={b:"\\\\.",r:0};this.ASM={cN:"string",b:"'",e:"'",i:"\\n",c:[this.BE],r:0};this.QSM={cN:"string",b:'"',e:'"',i:"\\n",c:[this.BE],r:0};this.CLCM={cN:"comment",b:"//",e:"$"};this.CBLCLM={cN:"comment",b:"/\\*",e:"\\*/"};this.HCM={cN:"comment",b:"#",e:"$"};this.NM={cN:"number",b:this.NR,r:0};this.CNM={cN:"number",b:this.CNR,r:0};this.BNM={cN:"number",b:this.BNR,r:0};this.inherit=function(r,s){var p={};for(var q in r){p[q]=r[q]}if(s){for(var q in s){p[q]=s[q]}}return p}}();hljs.LANGUAGES.cpp=function(){var a={keyword:{"false":1,"int":1,"float":1,"while":1,"private":1,"char":1,"catch":1,"export":1,virtual:1,operator:2,sizeof:2,dynamic_cast:2,typedef:2,const_cast:2,"const":1,struct:1,"for":1,static_cast:2,union:1,namespace:1,unsigned:1,"long":1,"throw":1,"volatile":2,"static":1,"protected":1,bool:1,template:1,mutable:1,"if":1,"public":1,friend:2,"do":1,"return":1,"goto":1,auto:1,"void":2,"enum":1,"else":1,"break":1,"new":1,extern:1,using:1,"true":1,"class":1,asm:1,"case":1,typeid:1,"short":1,reinterpret_cast:2,"default":1,"double":1,register:1,explicit:1,signed:1,typename:1,"try":1,"this":1,"switch":1,"continue":1,wchar_t:1,inline:1,"delete":1,alignof:1,char16_t:1,char32_t:1,constexpr:1,decltype:1,noexcept:1,nullptr:1,static_assert:1,thread_local:1,restrict:1,_Bool:1,complex:1},built_in:{std:1,string:1,cin:1,cout:1,cerr:1,clog:1,stringstream:1,istringstream:1,ostringstream:1,auto_ptr:1,deque:1,list:1,queue:1,stack:1,vector:1,map:1,set:1,bitset:1,multiset:1,multimap:1,unordered_set:1,unordered_map:1,unordered_multiset:1,unordered_multimap:1,array:1,shared_ptr:1}};return{dM:{k:a,i:"</",c:[hljs.CLCM,hljs.CBLCLM,hljs.QSM,{cN:"string",b:"'\\\\?.",e:"'",i:"."},{cN:"number",b:"\\b(\\d+(\\.\\d*)?|\\.\\d+)(u|U|l|L|ul|UL|f|F)"},hljs.CNM,{cN:"preprocessor",b:"#",e:"$"},{cN:"stl_container",b:"\\b(deque|list|queue|stack|vector|map|set|bitset|multiset|multimap|unordered_map|unordered_set|unordered_multiset|unordered_multimap|array)\\s*<",e:">",k:a,r:10,c:["self"]}]}}}();hljs.LANGUAGES.r={dM:{c:[hljs.HCM,{cN:"number",b:"\\b0[xX][0-9a-fA-F]+[Li]?\\b",e:hljs.IMMEDIATE_RE,r:0},{cN:"number",b:"\\b\\d+(?:[eE][+\\-]?\\d*)?L\\b",e:hljs.IMMEDIATE_RE,r:0},{cN:"number",b:"\\b\\d+\\.(?!\\d)(?:i\\b)?",e:hljs.IMMEDIATE_RE,r:1},{cN:"number",b:"\\b\\d+(?:\\.\\d*)?(?:[eE][+\\-]?\\d*)?i?\\b",e:hljs.IMMEDIATE_RE,r:0},{cN:"number",b:"\\.\\d+(?:[eE][+\\-]?\\d*)?i?\\b",e:hljs.IMMEDIATE_RE,r:1},{cN:"keyword",b:"(?:tryCatch|library|setGeneric|setGroupGeneric)\\b",e:hljs.IMMEDIATE_RE,r:10},{cN:"keyword",b:"\\.\\.\\.",e:hljs.IMMEDIATE_RE,r:10},{cN:"keyword",b:"\\.\\.\\d+(?![\\w.])",e:hljs.IMMEDIATE_RE,r:10},{cN:"keyword",b:"\\b(?:function)",e:hljs.IMMEDIATE_RE,r:2},{cN:"keyword",b:"(?:if|in|break|next|repeat|else|for|return|switch|while|try|stop|warning|require|attach|detach|source|setMethod|setClass)\\b",e:hljs.IMMEDIATE_RE,r:1},{cN:"literal",b:"(?:NA|NA_integer_|NA_real_|NA_character_|NA_complex_)\\b",e:hljs.IMMEDIATE_RE,r:10},{cN:"literal",b:"(?:NULL|TRUE|FALSE|T|F|Inf|NaN)\\b",e:hljs.IMMEDIATE_RE,r:1},{cN:"identifier",b:"[a-zA-Z.][a-zA-Z0-9._]*\\b",e:hljs.IMMEDIATE_RE,r:0},{cN:"operator",b:"<\\-(?!\\s*\\d)",e:hljs.IMMEDIATE_RE,r:2},{cN:"operator",b:"\\->|<\\-",e:hljs.IMMEDIATE_RE,r:1},{cN:"operator",b:"%%|~",e:hljs.IMMEDIATE_RE},{cN:"operator",b:">=|<=|==|!=|\\|\\||&&|=|\\+|\\-|\\*|/|\\^|>|<|!|&|\\||\\$|:",e:hljs.IMMEDIATE_RE,r:0},{cN:"operator",b:"%",e:"%",i:"\\n",r:1},{cN:"identifier",b:"`",e:"`",r:0},{cN:"string",b:'"',e:'"',c:[hljs.BE],r:0},{cN:"string",b:"'",e:"'",c:[hljs.BE],r:0},{cN:"paren",b:"[[({\\])}]",e:hljs.IMMEDIATE_RE,r:0}]}};
hljs.initHighlightingOnLoad();
</script>
</head>
<body>
<h2>Dimple with Knitr</h2>
<p>Let us first get the data</p>
<pre><code class="r">data &lt;- read.delim(&quot;http://pmsi-alignalytics.github.io/dimple/data/example_data.tsv&quot;)
### eliminate . to avoid confusion in javascript
colnames(data) &lt;- gsub(&quot;[.]&quot;, &quot;&quot;, colnames(data))
</code></pre>
<p>Let us now plot it.</p>
<pre><code class="r">require(rCharts)
d1 &lt;- dPlot(SalesValue ~ Price, groups = c(&quot;SKU&quot;, &quot;Channel&quot;, &quot;Owner&quot;), data = subset(data,
Date == &quot;01/12/2012&quot;), type = &quot;bubble&quot;, height = 400, width = 590, bounds = list(x = 60,
y = 30, width = 420, height = 330))
d1$xAxis(type = &quot;addMeasureAxis&quot;)
d1$yAxis(type = &quot;addMeasureAxis&quot;)
d1$legend(x = 530, y = 100, width = 60, height = 300, horizontalAlign = &quot;right&quot;)
d1$show(&quot;iframe&quot;)
</code></pre>
<iframe src=chart1.html seamless></iframe>
<style>
iframe {
width: 100%;
height: 400px;
}
</style>
</body>
</html>
Raw
index.md

Dimple with Knitr

Let us first get the data

data <- read.delim("http://pmsi-alignalytics.github.io/dimple/data/example_data.tsv")
### eliminate . to avoid confusion in javascript
colnames(data) <- gsub("[.]", "", colnames(data))

Let us now plot it.

require(rCharts)
d1 <- dPlot(SalesValue ~ Price, groups = c("SKU", "Channel", "Owner"), data = subset(data, 
    Date == "01/12/2012"), type = "bubble", height = 400, width = 590, bounds = list(x = 60, 
    y = 30, width = 420, height = 330))
d1$xAxis(type = "addMeasureAxis")
d1$yAxis(type = "addMeasureAxis")
d1$legend(x = 530, y = 100, width = 60, height = 300, horizontalAlign = "right")
d1$show("iframe")
<iframe src=chart1.html seamless></iframe> <style> iframe { width: 100%; height: 400px; } </style>
Raw
index.Rmd
## Dimple with Knitr
Let us first get the data
```{r}
data <- read.delim(
"http://pmsi-alignalytics.github.io/dimple/data/example_data.tsv"
)
### eliminate . to avoid confusion in javascript
colnames(data) <- gsub("[.]","",colnames(data))
```
Let us now plot it.
```{r chart1, commment = NA, results = 'asis', message = F, fig.path = ""}
require(rCharts)
d1 <- dPlot(
SalesValue~Price,
groups = c("SKU", "Channel", "Owner"),
data = subset(data, Date == "01/12/2012"),
type = "bubble",
height = 400,
width = 590,
bounds = list(x=60, y=30, width=420, height=330)
)
d1$xAxis( type = "addMeasureAxis" )
d1$yAxis( type = "addMeasureAxis" )
d1$legend(
x = 530,
y = 100,
width = 60,
height = 300,
horizontalAlign = "right"
)
d1$show('iframe')
```
<style>
iframe {
width: 100%;
height: 400px;
}
</style>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment