2f:Tb3c,container=htl.html`

No of companies

TotalCompanies[0].TotalCompanies}

Median Revenue

"$"+parseInt(MedianRevenue[0]["Median Revenue"])+"M"}

Median Employee Size

parseInt(MedianEmployeeSize[0]["Median Employee Size"])}

horPlot}

${viewof top50latest}

sunburstdemo}

activeBuyers}

${radar123}

`30:[] 2d:{"title":"Dashboard","cells":[{"id":0,"value":"# Dashboard","pinned":false,"hidden":false,"mode":"md"},{"id":53,"value":"import {radar123} from \"189866f21ea9a710\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"import {viewof filterValue} from \"8d62079c7010981c\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":115,"value":"import {data as HorData} from \"78aea307336a3f32\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":131,"value":"import {data50} from \"4bcdf6e1366abec0\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"target50Data = selectedCountry ==\"All\"? data50 : data50.filter(x=>x['Country'] == selectedCountry)","pinned":true,"hidden":true,"mode":"ojs"},{"id":65,"value":"import {viewof selectedCountry} from \"8d62079c7010981c\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":88,"value":"viewof selectedCountry","pinned":true,"hidden":false,"mode":"ojs"},{"id":67,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":75,"value":"fhData = selectedCountry ==\"All\" ? HorData : HorData.filter(x=>x['Country']==selectedCountry)","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"select distinct Count(TRIM(\"Company ID\")) as NoOfCompanies, TRIM(\"Simple Industry (Level 3)\") As IndustryLevel3 from fhData group by \"Simple Industry (Level 3)\" Order by Count(TRIM(\"Company ID\")) desc","pinned":true,"hidden":false,"mode":"sql","output":"","database":"null"},{"id":162,"value":"select Count(\"Company ID\") as TotalCompanies from HorData","pinned":true,"hidden":false,"mode":"sql","output":"","database":"var:HorData"},{"id":103,"value":"horPlot=Plot.plot({\n marginLeft:320,\n width:600,\n height:900,\n marginTop:8,\n x: {\n axis: null,\n percent: true,\n label:null \n },\n y : {\n label:null \n },\n marks: [\n Plot.areaX({tickSize:0}),\n Plot.barX(horizontalData, \n {x: \"NoOfCompanies\", \n y: \"IndustryLevel3\", \n sort: {y: \"x\", reverse: true},\n fill:\"#027148\",\n insetTop:2\n }\n )]\n})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":105,"value":"d3.select(horPlot).selectAll(\"svg > g > text\").attr(\"style\",\"font-size:12px;font-weight:bold\");","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"import {set} from \"@observablehq/synchronized-inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":143,"value":"viewof top50latest = Table(target50Data, [\"Company Name\", \"Founded Year\", \"Country\", \"State/Province\", \"Simple Industry (Level 3)\", \"Company Type (Private/Public)\", \"Ultimate Parent Company\",\"Detail\"])","pinned":true,"hidden":false,"mode":"ojs"},{"id":139,"value":"function Table(data, keys = Object.keys(data[0])) {\n const onclick = (e, row) => {\n for (const row of node.querySelectorAll(\"tbody tr\")) row.style.background = \"none\";\n e.currentTarget.style.background = \"#eee\";\n set(node, row);\n };\n const node = htl.html`

\n \n \n \n ${keys.map(key => htl.html``)}\n \n \n \n ${data.map(row => htl.html` onclick(e, row)}>\n ${keys.map(key => htl.html``)}\n `)}\n \n

\n ${key}\n
\n ${row[key]}\n

`;\n set(node, null);\n return node;\n}","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}