27:null 28:["$","title",null,{"children":"Dashboard | Nagaraj TV's Workspace | Observable"}] 2d: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}

`2e:[] 2b:{"id":"26aaa2f3b0b81a9d","slug":null,"title":"Dashboard","thumbnail":"0ec30b6f652742468d72de8f55b82381a6bca193ae8868c65ca71e3433e225d8","access_level":"public","create_time":"$D2023-11-03T07:36:20.926Z","update_time":"$D2023-11-03T10:39:05.506Z","view_time":null,"first_public_time":"$D2023-11-03T07:36:20.926Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"824529626ce38a98","login":"nagaraj-tv-ws","name":"Nagaraj TV's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/50611554d5959b275ec71ce9222d06b4571314ed34d820e6a60f1d2f8ebe6b45","tier":"starter_2024"},"version":189,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"28fd1255dff62f08","login":"nagaraj-tv","name":"Nagaraj TV","avatar_url":"https://avatars-next.observableusercontent.com/bc06fcd937a67bf2e14440098ce4150c7b3175ecb5739f8c94ef160f04b454af","tier":null}],"members":[{"type":"individual","id":"28fd1255dff62f08","login":"nagaraj-tv","name":"Nagaraj TV","avatar_url":"https://avatars-next.observableusercontent.com/bc06fcd937a67bf2e14440098ce4150c7b3175ecb5739f8c94ef160f04b454af","tier":null,"role":"editor"},{"type":"team","id":"824529626ce38a98","login":"nagaraj-tv-ws","name":"Nagaraj TV's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/50611554d5959b275ec71ce9222d06b4571314ed34d820e6a60f1d2f8ebe6b45","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Dashboard","cells":[{"id":0,"value":"# Dashboard","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":53,"value":"import {radar123} from \"189866f21ea9a710\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"import {viewof filterValue} from \"8d62079c7010981c\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"import {data as HorData} from \"78aea307336a3f32\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"import {data50} from \"4bcdf6e1366abec0\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"target50Data = selectedCountry ==\"All\"? data50 : data50.filter(x=>x['Country'] == selectedCountry)","pinned":true,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"import {viewof selectedCountry} from \"8d62079c7010981c\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"viewof selectedCountry","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"$2d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"fhData = selectedCountry ==\"All\" ? HorData : HorData.filter(x=>x['Country']==selectedCountry)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"null"},{"id":162,"value":"select Count(\"Company ID\") as TotalCompanies from HorData","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"d3.select(horPlot).selectAll(\"svg > g > text\").attr(\"style\",\"font-size:12px;font-weight:bold\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"import {set} from \"@observablehq/synchronized-inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2c:"$2b:body"