could be 0 like Garden = 0 or can be null like SportingEquip doesn't exist at all.
var options = {
backgroundColor: 'transparent',
hAxis: { minValue: 0, format: '0', gridlines: { count: -1 } },
colors: ['#0F2D52', '#789A3D', '#EE7623', '#231F20', '#7EA0C3'],
legend: { position: 'bottom', textStyle: {fontSize: 6}},
isStacked: true
};
var drawChart = function (data, options) {
var chartDomId = "purchase_trends";
var wrapper = new google.visualization.ChartWrapper({
chartType: 'BarChart',
dataTable: data,
options: options,
containerId: chartDomId
});
wrapper.draw();
};
var data;
this.LoadChart = function () {
if (data != null) {
drawChart(data, options);
} else {
return $.ajax({
type: 'GET',
url: '/Charts/GetPurchaseTrends',
dataType: "json",
cache: false,
success: function (jsonData) {
data = new google.visualization.DataTable({
cols: [
{ type: 'string', label: 'Year' },
{ type: 'number', label: 'Medication' },
{ type: 'number', label: 'Sporting Equip.' },
{ type: 'number', label: 'Groceries' },
{ type: 'number', label: 'Garden & Lawn' },
{ type: 'number', label: 'Miscellaneous' }
]
});
var results = jsonData;
if (results.Data.length > 0) {
for (var i = 0; i < results.Data.length; i++) {
var yearNumber = results.Data[i].Year;
var medication = results.Data[i].Medication;
var sportingEquip = results.Data[i].Sporting;
var groceries = results.Data[i].Groceries;
var garden = result.Data[i].Garden;
var miscellaneous = result.Data[i].Miscellaneous;
data.addRow([yearNumber.toString(), medication, sportingEquip, groceries, garden, miscellaneous]);
}
}
},
error: function (msg) {
console.log(msg);
},
complete: function () {
drawChart(data, options);
$(window).resize(function () {
drawChart(data, options);
});
}
});
}
};