Convert bool columns to numbers when charting.
Various chart types barf if they see a bool column, even though the data
inside is perfectly fine.
diff --git a/render.js b/render.js
index 49843de..b60a752 100644
--- a/render.js
+++ b/render.js
@@ -98,7 +98,7 @@
dheaders.push({
id: headers[i],
label: headers[i],
- type: types[i]
+ type: (types[i] != T_BOOL || !options.bool_to_num) ? types[i] : T_NUM
});
}
var ddata = [];
@@ -1201,7 +1201,10 @@
throw new Error('unknown chart type "' + charttype + '"');
}
$(el).height(window.innerHeight);
- datatable = dataToGvizTable(grid, { show_only_lastseg: true });
+ datatable = dataToGvizTable(grid, {
+ show_only_lastseg: true,
+ bool_to_num: true
+ });
} else {
var el = document.getElementById('viztable');
t = new google.visualization.Table(el);
@@ -1229,7 +1232,12 @@
enqueue(queue, chartops ? 'chart=' + chartops : 'view',
function(grid, done) {
- t.draw(datatable, options);
+ if (grid.data.length) {
+ t.draw(datatable, options);
+ } else {
+ var el = document.getElementById('vizchart');
+ el.innerHTML = 'Empty dataset.';
+ }
done(grid);
});
}