viewof example = {
const dat = d3.csvParse(`region,area,turnover,plan_turnover,gp,plan_gp
region1,area1,1330000.01,1000000,1330000.01,1000000
region1,area2,3000000,2900000,1330000.01,1000000
region1,area3,5000000,4500000,1330000.01,1000000
region1,area4,7000000,8000000,1330000.01,1000000
region2,area5,7000000,8000000,1330000.01,1000000`, d3.autoType)
const aq_dat = aq.from(dat)
.filter(aq.escape(d => d.turnover <= filter_turnover))
const post_aq_dat = aq_dat.objects()
var dom = html`<div id="app" style="overflow:auto;"></div>`;
yield dom;
pivottable(dom, {
title: 'Sample',
ui: true,
data: post_aq_dat,
params: {
rows: ["region"],
cols: ["area"],
aggregatorName: "Sum",
vals: ["turnover"],
rendererName: "Heatmap",
rendererOptions: {
table: {
clickCallback: function(e, value, filters, pivotData) {
var names = [];
pivotData.forEachMatchingRecord(filters, function(record) {
names.push(record.Name);
});
}
}
}
}
});
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
