2f:[{"id":"70aa34c99268ca47009bcff13cfb122c9a74d78cd1326e0166d3cbb22bc1a119a470c22d2dad95df734b7ffee031cb169ae4539eb892c6ef0e1735a6f80da607","href":"https://static.observableusercontent.com/files/70aa34c99268ca47009bcff13cfb122c9a74d78cd1326e0166d3cbb22bc1a119a470c22d2dad95df734b7ffee031cb169ae4539eb892c6ef0e1735a6f80da607","name":"Test.csv","type":"text/csv","lastModified":1698657082337.506,"size":40534016}] 2d:{"title":"","cells":[{"id":172,"value":"

No of companies

${TotalCompanies[0].TotalCompanies}

","pinned":false,"hidden":false,"mode":"html"},{"id":177,"value":"

Target Industries

","pinned":false,"hidden":false,"mode":"html"},{"id":5,"value":"Plot.plot({\n marginLeft:290,\n x: {\n axis: null,\n percent: true,\n label:null\n },\n y : {\n frequency:(d)=> d/1000,\n label:null\n },\n color: {scheme: \"Spectral\", legend: \"ramp\", width: 340, label: \"Age (years)\"},\n marks: [\n Plot.areaX({tickSize:0}),\n Plot.barX(ListOfItems, \n {x: \"NoOfCompanies\", \n y: \"IndustryLevel3\", \n sort: {y: \"x\", reverse: true},\n fill:\"#027148\"\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":159,"value":"await FileAttachment(\"Test.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"data = FileAttachment(\"Test.csv\").csv({typed:true});","pinned":true,"hidden":false,"mode":"ojs"},{"id":68,"value":"select distinct Count(TRIM(\"Company ID\")) as NoOfCompanies, TRIM(\"Simple Industry (Level 3)\") As IndustryLevel3 from data group by \"Simple Industry (Level 3)\" Order by Count(TRIM(\"Company ID\")) desc","pinned":true,"hidden":false,"mode":"sql","output":"ListOfItems","database":"var:data"},{"id":145,"value":"select Count(\"Company ID\") as TotalCompanies from data","pinned":true,"hidden":false,"mode":"sql","output":"TotalCompanies","database":"var:data"}],"files":"$W2f","stdlib":"1","titling":"auto"}