2b:null 2c:["$","title",null,{"children":"Hello, pivottable.js with filter | novotny1akub | Observable"}] 31:T459,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`

`; 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); }); } } } } }); } 32:[] 2f:{"id":"81996b27c6b8f2bc","slug":"hello-pivottable-js","title":"Hello, pivottable.js with filter","thumbnail":"2734254fce2300e978cd6232e0d97065b37e92533937c1438b67c19ff4d3e344","access_level":"public","create_time":"$D2022-09-12T15:45:49.079Z","update_time":"$D2022-09-12T16:18:42.199Z","view_time":null,"first_public_time":"$D2022-09-12T16:18:30.092Z","fork":{"id":"9b2bd9a29fe238d4","slug":"hello-pivottable-js","title":"Hello, pivottable.js","owner":{"id":"ebdd8a722ae381e2","login":"a10k","name":"Alok Pepakayala"}},"stars":0,"starred":false,"owner":{"type":"team","id":"82ed9e6aaba8acb2","login":"novotny1akub","name":"novotny1akub","avatar_url":"https://avatars-next.observableusercontent.com/40e4321204a4470fbee5dcc275c513d1f8bc8dbd5732a4f01aad221d0426f271","tier":"starter_2024"},"version":778,"publish_version":778,"role":null,"authored":false,"authors":[{"type":"individual","id":"1125ba366576bacb","login":"novotny1akub","name":"novotny1akub","avatar_url":"https://avatars-next.observableusercontent.com/40e4321204a4470fbee5dcc275c513d1f8bc8dbd5732a4f01aad221d0426f271","tier":null}],"members":[{"type":"individual","id":"1125ba366576bacb","login":"novotny1akub","name":"novotny1akub","avatar_url":"https://avatars-next.observableusercontent.com/40e4321204a4470fbee5dcc275c513d1f8bc8dbd5732a4f01aad221d0426f271","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Hello, pivottable.js with filter","cells":[{"id":0,"value":"md`# Hello, pivottable.js with filter`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":727,"value":"html`\n\n

For more details: https://github.com/nicolaskruchten/pivottable`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":767,"value":"viewof filter_turnover = Inputs.range(\n [0, 7000000], \n {value: 7000000, step: 1, label: \"Filter turnover:\"}\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":713,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":729,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":734,"value":"md`### Dependencies`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":710,"value":"styles = html`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":560,"value":"pivottable = {\n const $ = await require(\"https://code.jquery.com/jquery-3.5.1.min.js\");\n const jqui = await require('https://code.jquery.com/ui/1.12.1/jquery-ui.min.js');\n const pt = await require('https://pivottable.js.org/dist/pivot.js');\n\n return function(app, sample) {\n const { title, ui, data, params } = sample;\n app.innerHTML = '';\n\n const e1 = document.createElement('div');\n e1.setAttribute('id', 'pivot');\n app.appendChild(e1);\n\n if (ui) window.$('#pivot').pivotUI(data, params);\n else window.$('#pivot').pivot(data, params);\n\n return true;\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"