2c:null 2d:["$","title",null,{"children":"RIC Rolling 12 mth Bar Chart by Sector | Steve Pegg | Observable"}] 32:T1f17,chart = { // const svg = d3.create("svg") //.attr("viewBox", [0, 0, width, height]); const svg = d3.select(DOM.svg(width, height)) svg.append("g") .selectAll("g") .data(seriesQ1) .join("g") .attr("transform", d => `translate(${x0("Q1")},0)`) .attr("fill", d => color(d.key)) .selectAll("rect") .data(d => d) .join("rect") .attr("class", d => d.data.score) .on("mouseover", function(event, d) { var thislineclass = d3.select(this).attr("class") var thisclass = d3.select(this).attr("class").split(" ") svg.append("path") .attr("id", "sline") .attr("fill", "none") .attr("stroke", "navy") .attr("stroke-width", 1) .attr("d", sline((dddd).filter(function (d) { return d.sector === thislineclass}))) if(!thisclass[1]) { thisclass[1] = thisclass[0]} d3.selectAll("rect").attr("opacity",0.1) d3.selectAll("." + thisclass[0] + "." + thisclass[1]).attr("opacity",1) }) .on("mouseleave", function(event, d) { d3.select("#sline").remove(); d3.selectAll("rect").attr("opacity",1)}) .style("stroke", "white") .style("stroke-width", 1) .attr("x", (d, i) => x1(d.data.score)) .attr("y", d => y(d[1])) .attr("height", d => y(d[0]) - y(d[1])) .attr("width", x1.bandwidth()) .append("title") .text(d => `${d.data.score} ${d.key}`); svg.append("g") .selectAll("g") .data(seriesQ2) .join("g") .attr("transform", d => `translate(${x0("Q1")-margin.left},0)`) .attr("fill", d => color(d.key)) .selectAll("rect") .data(d => d) .join("rect") .attr("class", d => d.data.score) .on("mouseover", function(event, d) { var thislineclass = d3.select(this).attr("class") var thisclass = d3.select(this).attr("class").split(" ") svg.append("path") .attr("id", "sline") .attr("fill", "none") .attr("stroke", "navy") .attr("stroke-width", 1) .attr("d", sline((dddd).filter(function (d) { return d.sector === thislineclass}))) if(!thisclass[1]) { thisclass[1] = thisclass[0]} d3.selectAll("rect").attr("opacity",0.1) d3.selectAll("." + thisclass[0] + "." + thisclass[1]).attr("opacity",1) }) .on("mouseleave", function(event, d) { d3.select("#sline").remove(); d3.selectAll("rect").attr("opacity",1)}) .style("stroke", "white") .style("stroke-width", 1) .attr("x", (d, i) => x2(d.data.score)) .attr("y", d => y(d[1])) .attr("height", d => y(d[0]) - y(d[1])) .attr("width", x1.bandwidth()) .append("title") .text(d => `${d.data.score} ${d.key}`); svg.append("g") .selectAll("g") .data(seriesQ3) .join("g") .attr("transform", d => `translate(${x0("Q1")-margin.left},0)`) .attr("fill", d => color(d.key)) .selectAll("rect") .data(d => d) .join("rect") .attr("class", d => d.data.score) .on("mouseover", function(event, d) { var thislineclass = d3.select(this).attr("class") var thisclass = d3.select(this).attr("class").split(" ") svg.append("path") .attr("id", "sline") .attr("fill", "none") .attr("stroke", "navy") .attr("stroke-width", 1) .attr("d", sline((dddd).filter(function (d) { return d.sector === thislineclass}))) if(!thisclass[1]) { thisclass[1] = thisclass[0]} d3.selectAll("rect").attr("opacity",0.1) d3.selectAll("." + thisclass[0] + "." + thisclass[1]).attr("opacity",1) }) .on("mouseleave", function(event, d) { d3.select("#sline").remove(); d3.selectAll("rect").attr("opacity",1)}) .style("stroke", "white") .style("stroke-width", 1) .attr("x", (d, i) => x3(d.data.score)) .attr("y", d => y(d[1])) .attr("height", d => y(d[0]) - y(d[1])) .attr("width", x1.bandwidth()) .append("title") .text(d => `${d.data.score} ${d.key}`); svg.append("g") .selectAll("g") .data(seriesQ4) .join("g") .attr("transform", d => `translate(${x0("Q1")-margin.left},0)`) .attr("fill", d => color(d.key)) .selectAll("rect") .data(d => d) .join("rect") .attr("class", d => d.data.score) .on("mouseover", function(event, d) { var thislineclass = d3.select(this).attr("class") var thisclass = d3.select(this).attr("class").split(" ") svg.append("path") .attr("id", "sline") .attr("fill", "none") .attr("stroke", "navy") .attr("stroke-width", 1) .attr("d", sline((dddd).filter(function (d) { return d.sector === thislineclass}))) if(!thisclass[1]) { thisclass[1] = thisclass[0]} d3.selectAll("rect").attr("opacity",0.1) d3.selectAll("." + thisclass[0] + "." + thisclass[1]).attr("opacity",1) }) .on("mouseleave", function(event, d) { d3.select("#sline").remove(); d3.selectAll("rect").attr("opacity",1)}) .style("stroke", "white") .style("stroke-width", 1) .attr("x", (d, i) => x4(d.data.score)) .attr("y", d => y(d[1])) .attr("height", d => y(d[0]) - y(d[1])) .attr("width", x1.bandwidth()) .append("title") .text(d => `${d.data.score} ${d.key}`); const t = svg.transition() .duration(750); const gx = svg.append("g") .call(xAxis); const gx2 = svg.append("g") .call(xAxis2); const gx3 = svg.append("g") .call(xAxis3); const gx4 = svg.append("g") .call(xAxis4); svg.append("g") .call(yAxis) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') // .attr("transform", "rotate(90)") .style("text-anchor", "start"); gx.transition(t) .call(xAxis) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') .attr("transform", "rotate(90)") .style("text-anchor", "start"); gx2.transition(t) .call(xAxis2) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') .attr("transform", "rotate(90)") .style("text-anchor", "start"); gx3.transition(t) .call(xAxis3) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') .attr("transform", "rotate(90)") .style("text-anchor", "start"); gx4.transition(t) .call(xAxis4) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') .attr("transform", "rotate(90)") .style("text-anchor", "start"); svg.append("text") .attr("class", "x label") .attr("text-anchor", "center") .attr("x", x0("Q1")) .attr("y", height) .text("Change over ----3m"); svg.append("text") .attr("class", "x label") .attr("text-anchor", "center") .attr("x", x0("Q2")+85) .attr("y", height) .text("6m"); svg.append("text") .attr("class", "x label") .attr("text-anchor", "center") .attr("x", x0("Q3") + 85) .attr("y", height ) .text("9m"); svg.append("text") .attr("class", "x label") .attr("text-anchor", "center") .attr("x", x0("Q4")+85) .attr("y", height) .text("12m"); return svg.node(); }33:T885,function dataxx (data) { const arrayLength = data.length; const subarr = []; let arr = []; let q1 = 0; let q2 = 0; let q3 = 0; let q4 = 0; let totalq1 = 0; let totalq2 = 0; let totalq3 = 0; let totalq4 = 0; const sectors = [...new Set(data.map(d => d.Sector))] sectors.forEach(function(sec) { // console.log(sec) totalq1 = 0; totalq2 = 0; totalq3 = 0; totalq4 = 0; data.forEach(function(d) { if(d.Sector === sec) { // // console.log(d.Code) //for (var i = 0; i < arrayLength; i++) { d["Local price"] = +d["Local price"] d.month3 = +d.month3 d.month6= +d.month6 d.month9 = +d.month9 d.month12 = +d.month12 q1 = 0; q2 = 0; q3 = 0; q4 = 0; // console.log(d["Local price"]) // if (d["Local price"] > 0 && d.month3 > 0) {q1 = ((d.month3 - d["Local price"]))/d["Local price"]} // if (d.month3 > 0 && d.month6 > 0) {q2 = ((d.month6 - d.month3))/d.month3} // if (d.month6 > 0 && d.month9 > 0) {q3 = ((d.month9 - d.month6))/d.month6} // if (d.month9 > 0 && d.month12 > 0) {q4 = ((d.month12 - d.month9))/d.month9} if (d.month12 > 0 && d.month9 >= 0) {q1 = ((d.month9 - d.month12))/d.month12} if (d.month12 > 0 && d.month6 >= 0) {q2 = ((d.month6 - d.month12))/d.month12} if (d.month12 > 0 && d.month3 >= 0) {q3 = ((d.month3 - d.month12))/d.month12} if (d.month12 > 0 && d["Local price"] >= 0) {q4 = ((d["Local price"] - d.month12))/d.month12} if(q1>0) { totalq1 += q1}; // console.log(q1)} if(q2>0) { totalq2 += q2} if(q3>0) { totalq3 += q3} if(q4>0) { totalq4 += q4} //} } }) arr.push({"sector": sec, "quarter":"Q1", "total": totalq1*100}) arr.push({"sector": sec, "quarter":"Q2", "total": totalq2*100}) arr.push({"sector": sec, "quarter":"Q3", "total": totalq3*100}) arr.push({"sector": sec, "quarter":"Q4", "total": totalq4*100}) // return subarr.push({"sector": sec, "code": q1}) // return arr.push({"sector": sec, "Q1": totalq1*100,"Q2": totalq2*100,"Q3": totalq3*100,"Q4": totalq4*100}) return arr }) return arr }34:T663,function swatches({ color, columns = null, format = x => x, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 }) { const id = DOM.uid().id; if (columns !== null) return html`

${color.domain().map(value => { const label = format(value); return html`

${document.createTextNode(label)}

`; })}

`; return html`

${color.domain().map(value => html`${document.createTextNode(format(value))}`)}

`; }35:[] 30:{"id":"7b97f6c66220f46f","slug":"ric-rolling-12-mth-bar-chart-by-sector","title":"RIC Rolling 12 mth Bar Chart by Sector","thumbnail":"58d714e6ab347beb02eec480927e462150188f20d6cd2f1668b87126ce3ad99c","access_level":"public","create_time":"$D2021-02-23T13:55:03.095Z","update_time":"$D2021-03-11T11:08:30.873Z","view_time":null,"first_public_time":"$D2021-03-03T13:17:48.090Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":"starter_2024","bio":"Mainly coding for fun these days!"},"version":1011,"publish_version":1011,"role":null,"authored":false,"authors":[{"type":"individual","id":"1281bb8ce5440734","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":null,"bio":"Mainly coding for fun these days!"}],"members":[{"type":"individual","id":"1281bb8ce5440734","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"6ff40e8e4a2133a9","slug":"ric","title":"RIC","owner":{"id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg"}},"type":"notebook","body":{"titling":"auto","title":"RIC Rolling 12 mth Bar Chart by Sector","cells":[{"id":0,"value":"md`# RIC Rolling 12 mth Bar Chart by Sector \n\n% growth by sector and by quarter from baseline today -365d. Hover over bars.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"swatches({\n color: color,\n columns: \"180px\",\n //labelFormat: l => l.replace(\"2.0\", \">=2.0\")\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":760,"value":"sline = d3\n .line()\n .curve(d3.curveMonotoneX) \n //.defined(d => !isNaN(d.sector))\n .x(d => x0(d.quarter) + x1(d.sector)) \n .y(d => y(d.total));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"ee = x0(\"Q2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"x0 = d3.scaleBand()\n .domain([\"Q1\",\"Q2\",\"Q3\",\"Q4\"]) // .domain(data.map(d => d[groupKey]))\n .rangeRound([margin.left, width - margin.left ])\n .paddingInner(0.2)\n // .paddingOuter(0.1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"x1 = d3.scaleBand()\n .domain(domainkeys) //.domain(keys)\n .rangeRound([x0(\"Q1\"), x0.bandwidth()])\n // .paddingInner(0.05)\n // .paddingOuter(0.05)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":834,"value":"x22 = x1.copy().rangeRound([x0(\"Q2\"), (x0(\"Q2\") + x0.bandwidth())])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"x2 = d3.scaleBand()\n .domain(domainkeys) //.domain(keys)\n .rangeRound([x0(\"Q2\"), x0(\"Q2\") + x0.bandwidth()])\n // .padding(0.05)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"x3 = d3.scaleBand()\n .domain(domainkeys) //.domain(keys)\n .rangeRound([x0(\"Q3\"), x0(\"Q3\") + x0.bandwidth()])\n// .padding(0.05)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"x4 = d3.scaleBand()\n .domain(domainkeys) //.domain(keys)\n .rangeRound([x0(\"Q4\"), x0(\"Q4\") + x0.bandwidth()])\n // .padding(0.05)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"y = d3.scaleLinear()\n .domain([d3.min(seriesQ2, d => d3.min(d, d => d[0])), d3.max(seriesQ4, d => d3.max(d, d => d[1]))]) // .domain([0, d3.max(dataQ1, d => d3.max(keys, key => d[key]))]).nice()\n .rangeRound([height - margin.bottom, margin.top])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"color = d3.scaleOrdinal() \n .domain(data.map(d => d.ShortCode))\n.range([\"#5b9291\",\"#264d7e\",\"#2a283d\",\"#173679\",\"#2c3e75\",\"#78adc2\",\"#1f4b61\",\"#2458af\",\"#a7c6eb\",\"#4f81c5\",\"#bcd890\",\"#698b47\",\"#4b5729\",\"#6a7031\",\"#3e4630\",\"#33533b\",\"#428b64\",\"#44945e\",\"#8fc693\",\"#364a20\",\"#3b3629\",\"#506b52\",\"#6b6f5a\",\"#4f5138\",\"#fef963\",\"#9e7339\",\"#7b6b4f\",\"#fdf07a\",\"#fdd906\",\"#f6c870\",\"#d4b97d\",\"#fde706\",\"#f4f0bd\",\"#fef6bf\",\"#feeba8\",\"#eedfa5\",\"#e6c18d\",\"#e4cf93\",\"#f3d163\",\"#74542f\",\"#402d21\",\"#61361e\",\"#845b4d\",\"#464334\",\"#c98a71\",\"#83422b\",\"#f3b28b\",\"#693b3f\",\"#613339\",\"#e8a1a2\",\"#793932\",\"#573320\",\"#bb3016\",\"#c41c22\",\"#8b1a32\",\"#982d57\",\"#dd3524\",\"#a83c19\",\"#e45523\"\n\n\n\n])\n\n//d3.scaleSequential(d3.interpolateViridis) https://jnnnnn.blogspot.com/2017/02/distinct-colours-2.html\n // .domain([0, 70]);\n\n//","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"formatValue = x => isNaN(x) ? \"N/A\" : x.toLocaleString(\"en\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"xAxis = g => g\n .attr(\"transform\", `translate(30,${height - margin.bottom})`)\n .call(d3.axisBottom(x1).tickSizeOuter(0))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"xAxis2 = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x2).tickSizeOuter(0))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"xAxis3 = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x3).tickSizeOuter(0))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"xAxis4 = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x4).tickSizeOuter(0))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${0},0)`)\n .call(d3.axisLeft(y).ticks(null, \"s\"))\n .call(g => g.select(\".domain\").remove())\n // .call(g => g.select(\".tick:last-of-type text\").clone()\n // .attr(\"x\", 3)\n // .attr(\"text-anchor\", \"start\")\n // .attr(\"font-weight\", \"bold\")\n // .text(data.y))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"groupKey = [\"Q1\",\"Q2\",\"Q3\",\"Q4\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"keys = [...new Set(data.map(d => d.ShortCode))]//data.columns.slice(12,14)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"domainkeys = [...new Set(data.map(d => d.Sector))]//data.columns.slice(12,14)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"margin = ({top: 10, right: 10, bottom: 150, left: 30})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"//xxx= d3.rollups(dddd, v => d3.sum(v, d => +d.Q1), d => d.sector)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"//series = d3.stack().keys([\"Q1\", \"Q2\", \"Q3\",\"Q4\"])(dddd) //[...new Set(dddd.map(d => d.code))]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"seriesQ2 = d3.stack()\n .keys([...new Set(data.map(d => d.ShortCode))]).offset(d3.stackOffsetDiverging)\n (dataQ2)\n .map(d => (d.forEach(v => v.key = d.key), d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":424,"value":"seriesQ4 = d3.stack()\n .keys([...new Set(data.map(d => d.ShortCode))]).offset(d3.stackOffsetDiverging)\n (dataQ4)\n .map(d => (d.forEach(v => v.key = d.key), d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":489,"value":"seriesQ3 = d3.stack()\n .keys([...new Set(data.map(d => d.ShortCode))]).offset(d3.stackOffsetDiverging)\n (dataQ3)\n .map(d => (d.forEach(v => v.key = d.key), d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"seriesQ1 = d3.stack()\n .keys([...new Set(data.map(d => d.ShortCode))]).offset(d3.stackOffsetDiverging)\n (dataQ1)\n .map(d => (d.forEach(v => v.key = d.key), d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"EST = [...new Set(data.map(d => d.Sector))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"dataQ1 = dataQ1routine(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"dataQ2 = dataQ2routine(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"dataQ3 = dataQ3routine(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"dataQ4 = dataQ4routine(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"function dataQ1routine (data) {\n\nlet obj = {}; \nlet arr = []; \nlet q1 = 0;\nlet total = 0 \nconst sectors = [...new Set(data.map(d => d.Sector))]\n \n sectors.forEach(function(sec) { \n total = 0\n // if(sec !== \"Gold\" && sec !== \"Fund\" && sec !== \"Trust\") {\nobj = {}; \n data.forEach(function(d,i) { \n if(sec === d.Sector) { \n if (d.month12 > 0 && d.month9 > 0) {q1 = ((d.month9 - d.month12))/d.month12} \n obj[\"score\"] = sec;\n obj[d.ShortCode] = q1 * 100; \n if(q1 > 0) {total += (q1 * 100)}; \n // obj[\"total\"] = total \n } \n })\n \n arr.push(obj) \n // }\n })\n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"function dataQ2routine (data) {\n\nlet obj = {}; \nlet arr = []; \nlet q2 = 0;\nconst sectors = [...new Set(data.map(d => d.Sector))]\n \n sectors.forEach(function(sec) { \n // if(sec !== \"Gold\" && sec !== \"Fund\" && sec !== \"Trust\") { \nobj = {}; \n data.forEach(function(d,i) { \n if(sec === d.Sector) { \n if (d.month12 > 0 && d.month6 > 0) {q2 = ((d.month6 - d.month12))/d.month12} //[\"Local price\"]\n obj[\"score\"] = sec;\n obj[d.ShortCode] = q2 * 100; \n } \n })\n \n arr.push(obj) \n // }\n })\n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"function dataQ3routine (data) {\n\nlet obj = {}; \nlet arr = []; \nlet q3 = 0;\nconst sectors = [...new Set(data.map(d => d.Sector))]\n \n sectors.forEach(function(sec) { \n// if(sec !== \"Gold\" && sec !== \"Fund\" && sec !== \"Trust\") { \nobj = {}; \n data.forEach(function(d,i) { \n if(sec === d.Sector) { \n if (d.month12 > 0 && d.month3 > 0) {q3 = ((d.month3 - d.month12))/d.month12} \n obj[\"score\"] = sec;\n obj[d.ShortCode] = q3 * 100; \n } \n })\n \n arr.push(obj) \n // }\n })\n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":283,"value":"function dataQ4routine (data) {\n\nlet obj = {}; \nlet arr = []; \nlet q4 = 0;\nconst sectors = [...new Set(data.map(d => d.Sector))]\n \n sectors.forEach(function(sec) { \n// if(sec !== \"Gold\" && sec !== \"Fund\" && sec !== \"Trust\") {\n \n obj = {}; \n data.forEach(function(d,i) { \n if(sec === d.Sector) { \n if (d.month12 > 0 && d[\"Local price\"] > 0) {q4 = ((d[\"Local price\"] - d.month12))/d.month12} \n obj[\"score\"] = sec;\n obj[d.ShortCode] = q4 * 100; \n } \n })\n \n arr.push(obj) \n// } \n })\n \n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"dddd = dataxx(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"data = Object.assign(await d3.tsv(url), d3.autoType).filter(function (d) {return d.Sector !== \"Gold\" && d.Sector !== \"Fund\" && d.Sector !== \"Trust\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"url = `https://sjp7001.herokuapp.com/${google_sheet_url}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"google_sheet_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vR7Zlm2MmvOZMoSBf3b62Km7XVcXur-nWKSAB-LKgXlDZr4ivTHi0iJSmzNpxq0P-ZyibkcAw9juBJT/pub?output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"width = 1000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"height = 650","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"function entity(character) {\n return `&#${character.charCodeAt(0).toString()};`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"sequentialScale(50);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":635,"value":"sequentialScale = d3.scaleSequential()\n .domain([0, 100])\n .interpolator(d3.interpolateRainbow);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 31:"$30:body"