2c:null 2d:["$","title",null,{"children":"Untitled | GfK Displayr Engineering | Observable"}] 32:T664,baStyle = html``33:T42d,function cellFormatter() { return (x,i) => { const kpi = kpis[i] const revenue = SwitchButtons == 'Revenue'//(kpi.search("REVENUE") > -1) const quantity = SwitchButtons == 'Quantity'//(kpi.search("QUANTITY") > -1) const percent = (kpi.search("YoY Chg%") > -1) /* bidirectional means it can be positive but also negative */ const divider = percent? 100: 1 let format = "" if(percent) {format = "+,.1%"} //else if(percent && !bidirectional) {format = ",.1%"} //else if (!percent) {format = ".1f"} else if(revenue) { format = "~s"} else if(quantity) { format = ".9"} return htl.html`

${isNaN(x)? "": d3.format(format)( (x/divider) )}` } }34:T401,function cellFormatterSplit(colName) { return (x,i) => { const y = data_relatives[i][colName] const kpi_absolute = kpis_absolute[i] const kpi_relative = kpis_relative[i] let format_absolute = SwitchButtons == 'Revenue'? "~s": ".9" let format_relative = "+,.1%" return htl.html`

${isNaN(x)? "": d3.format(format_absolute)( (x) )}
${isNaN(y)? "": d3.format(format_relative)( (y/100) )}

` } }35:T1d52,dataMockDisplayr = ({"data":[{"Current Week":0,"Rolling 4 Weeks":95.64,"QTR":242.07,"YTD":6735.1199,"MAT":946.27,"_row":"REVENUE AV ACCESSORIES"},{"Current Week":-100,"Rolling 4 Weeks":-45.0029,"QTR":-61.0124,"YTD":137.1513,"MAT":-66.6808,"_row":"REVENUE AV ACCESSORIES YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":116.52,"YTD":116.52,"MAT":116.52,"_row":"REVENUE CELLULAR PHONES"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":-30.8569,"YTD":-87.0958,"MAT":-87.0958,"_row":"REVENUE CELLULAR PHONES YoY Chg%"},{"Current Week":32714.7499,"Rolling 4 Weeks":141201.6003,"QTR":281932.4299,"YTD":1534857.9103,"MAT":1066859.6494,"_row":"REVENUE DISHWASHERS & WASTE DISPOSALS"},{"Current Week":223.115,"Rolling 4 Weeks":87.6219,"QTR":-6.3667,"YTD":79.0963,"MAT":24.4875,"_row":"REVENUE DISHWASHERS & WASTE DISPOSALS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":0,"YTD":0,"MAT":0,"_row":"REVENUE DVD & BLURAY HARDWARE"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":"NaN","YTD":"NaN","MAT":"NaN","_row":"REVENUE DVD & BLURAY HARDWARE YoY Chg%"},{"Current Week":30351.9605,"Rolling 4 Weeks":79988.8809,"QTR":227014.1619,"YTD":977340.2343,"MAT":699640.4227,"_row":"REVENUE HOME AUDIO"},{"Current Week":98.5908,"Rolling 4 Weeks":-14.1016,"QTR":5.4967,"YTD":90.5687,"MAT":36.4209,"_row":"REVENUE HOME AUDIO YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":2337.28,"QTR":6658.2501,"YTD":20182.4199,"MAT":17678.1398,"_row":"REVENUE IT ACCESSORIES"},{"Current Week":"NaN","Rolling 4 Weeks":-234.4609,"QTR":298.8122,"YTD":79.3378,"MAT":57.0851,"_row":"REVENUE IT ACCESSORIES YoY Chg%"},{"Current Week":137987.0001,"Rolling 4 Weeks":518388.4104,"QTR":1945542.8659,"YTD":6521301.9685,"MAT":4787524.4364,"_row":"REVENUE LAUNDRY"},{"Current Week":68.2027,"Rolling 4 Weeks":28.3483,"QTR":81.1933,"YTD":73.6742,"MAT":27.5005,"_row":"REVENUE LAUNDRY YoY Chg%"},{"Current Week":36557.629,"Rolling 4 Weeks":132229.7687,"QTR":238967.0901,"YTD":968663.0292,"MAT":818298.4946,"_row":"REVENUE MICROWAVE"},{"Current Week":55.6798,"Rolling 4 Weeks":58.4397,"QTR":11.3279,"YTD":35.4967,"MAT":14.4637,"_row":"REVENUE MICROWAVE YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":1389.5601,"QTR":7082.6,"YTD":55779.0701,"MAT":48410.2891,"_row":"REVENUE OCC Laundry"},{"Current Week":"NaN","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"REVENUE OCC Laundry YoY Chg%"},{"Current Week":1823.49,"Rolling 4 Weeks":4215.1401,"QTR":32073.6707,"YTD":171149.8306,"MAT":105657.6703,"_row":"REVENUE OCC Refrigeration"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":2362.2431,"YTD":145.7054,"MAT":51.6838,"_row":"REVENUE OCC Refrigeration YoY Chg%"},{"Current Week":164.35,"Rolling 4 Weeks":657.4,"QTR":10506.71,"YTD":19140.8203,"MAT":19140.8203,"_row":"REVENUE OCC Smalls"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"REVENUE OCC Smalls YoY Chg%"},{"Current Week":3077.8899,"Rolling 4 Weeks":3077.8899,"QTR":120846.3828,"YTD":221938.4928,"MAT":191507.3604,"_row":"REVENUE OCC Television"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":138.3838,"YTD":189.1696,"MAT":149.5201,"_row":"REVENUE OCC Television YoY Chg%"},{"Current Week":215770.3293,"Rolling 4 Weeks":618988.85,"QTR":1851569.7642,"YTD":7070735.1534,"MAT":4927590.9914,"_row":"REVENUE REFRIGERATION"},{"Current Week":125.3886,"Rolling 4 Weeks":4.446,"QTR":28.3077,"YTD":91.3523,"MAT":33.3533,"_row":"REVENUE REFRIGERATION YoY Chg%"},{"Current Week":844274.8608,"Rolling 4 Weeks":1853693.9414,"QTR":5920661.6468,"YTD":23636217.8241,"MAT":15849496.1975,"_row":"REVENUE TELEVISION"},{"Current Week":62.0639,"Rolling 4 Weeks":-17.1516,"QTR":-11.3873,"YTD":55.3691,"MAT":4.1843,"_row":"REVENUE TELEVISION YoY Chg%"},{"Current Week":93714.5595,"Rolling 4 Weeks":237140.4685,"QTR":817330.7156,"YTD":2893124.4932,"MAT":2023372.5961,"_row":"REVENUE VACUUM CLEANERS"},{"Current Week":176.9847,"Rolling 4 Weeks":150.3967,"QTR":185.7447,"YTD":413.968,"MAT":259.4553,"_row":"REVENUE VACUUM CLEANERS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":1,"QTR":3,"YTD":44,"MAT":7,"_row":"QUANTITY AV ACCESSORIES"},{"Current Week":-100,"Rolling 4 Weeks":-50,"QTR":-57.1429,"YTD":29.4118,"MAT":-79.4118,"_row":"QUANTITY AV ACCESSORIES YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":2,"YTD":2,"MAT":2,"_row":"QUANTITY CELLULAR PHONES"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":-50,"YTD":-84.6154,"MAT":-84.6154,"_row":"QUANTITY CELLULAR PHONES YoY Chg%"},{"Current Week":32,"Rolling 4 Weeks":121,"QTR":233,"YTD":1280,"MAT":875,"_row":"QUANTITY DISHWASHERS & WASTE DISPOSALS"},{"Current Week":300,"Rolling 4 Weeks":86.1538,"QTR":2.193,"YTD":87.6833,"MAT":28.2991,"_row":"QUANTITY DISHWASHERS & WASTE DISPOSALS YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":0,"QTR":0,"YTD":0,"MAT":0,"_row":"QUANTITY DVD & BLURAY HARDWARE"},{"Current Week":"NaN","Rolling 4 Weeks":"NaN","QTR":"NaN","YTD":"NaN","MAT":"NaN","_row":"QUANTITY DVD & BLURAY HARDWARE YoY Chg%"},{"Current Week":65,"Rolling 4 Weeks":136,"QTR":493,"YTD":2238,"MAT":1541,"_row":"QUANTITY HOME AUDIO"},{"Current Week":75.6757,"Rolling 4 Weeks":-47.2868,"QTR":0,"YTD":72.0215,"MAT":18.4473,"_row":"QUANTITY HOME AUDIO YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":4,"QTR":5,"YTD":17,"MAT":14,"_row":"QUANTITY IT ACCESSORIES"},{"Current Week":"NaN","Rolling 4 Weeks":-500,"QTR":150,"YTD":112.5,"MAT":75,"_row":"QUANTITY IT ACCESSORIES YoY Chg%"},{"Current Week":127,"Rolling 4 Weeks":438,"QTR":1666,"YTD":5708,"MAT":4156,"_row":"QUANTITY LAUNDRY"},{"Current Week":54.878,"Rolling 4 Weeks":11.4504,"QTR":71.223,"YTD":72.5514,"MAT":25.6348,"_row":"QUANTITY LAUNDRY YoY Chg%"},{"Current Week":195,"Rolling 4 Weeks":581,"QTR":1087,"YTD":4264,"MAT":3567,"_row":"QUANTITY MICROWAVE"},{"Current Week":95,"Rolling 4 Weeks":70.3812,"QTR":4.5192,"YTD":33.6258,"MAT":11.7831,"_row":"QUANTITY MICROWAVE YoY Chg%"},{"Current Week":0,"Rolling 4 Weeks":2,"QTR":7,"YTD":62,"MAT":52,"_row":"QUANTITY OCC Laundry"},{"Current Week":"NaN","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"QUANTITY OCC Laundry YoY Chg%"},{"Current Week":3,"Rolling 4 Weeks":6,"QTR":38,"YTD":198,"MAT":128,"_row":"QUANTITY OCC Refrigeration"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":1800,"YTD":104.1237,"MAT":31.9588,"_row":"QUANTITY OCC Refrigeration YoY Chg%"},{"Current Week":1,"Rolling 4 Weeks":4,"QTR":67,"YTD":116,"MAT":116,"_row":"QUANTITY OCC Smalls"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":"Inf","YTD":"Inf","MAT":"Inf","_row":"QUANTITY OCC Smalls YoY Chg%"},{"Current Week":3,"Rolling 4 Weeks":3,"QTR":140,"YTD":265,"MAT":227,"_row":"QUANTITY OCC Television"},{"Current Week":"Inf","Rolling 4 Weeks":"Inf","QTR":211.1111,"YTD":248.6842,"MAT":198.6842,"_row":"QUANTITY OCC Television YoY Chg%"},{"Current Week":123,"Rolling 4 Weeks":350,"QTR":1063,"YTD":4148,"MAT":2769,"_row":"QUANTITY REFRIGERATION"},{"Current Week":98.3871,"Rolling 4 Weeks":-6.4171,"QTR":29.9511,"YTD":97.1483,"MAT":31.6065,"_row":"QUANTITY REFRIGERATION YoY Chg%"},{"Current Week":471,"Rolling 4 Weeks":1135,"QTR":3726,"YTD":14371,"MAT":9744,"_row":"QUANTITY TELEVISION"},{"Current Week":58.0537,"Rolling 4 Weeks":-6.1208,"QTR":-0.9306,"YTD":57.767,"MAT":6.9711,"_row":"QUANTITY TELEVISION YoY Chg%"},{"Current Week":108,"Rolling 4 Weeks":265,"QTR":952,"YTD":3504,"MAT":2378,"_row":"QUANTITY VACUUM CLEANERS"},{"Current Week":200,"Rolling 4 Weeks":154.8077,"QTR":220.5387,"YTD":488.9076,"MAT":299.6639,"_row":"QUANTITY VACUUM CLEANERS YoY Chg%"}]}) 36:[] 30:{"id":"9bd52b0f072fc01e","slug":null,"title":"","thumbnail":"c72acce51ee5fb5c5e36f759e8e3b923bd536b9ddcd4da6483691f2977f4453e","access_level":"public","create_time":"$D2022-10-06T21:35:20.074Z","update_time":"$D2022-10-18T06:46:36.362Z","view_time":null,"first_public_time":"$D2022-10-06T21:35:36.745Z","has_unpublished_edits":null,"fork":{"id":"40807587bd7d4285","slug":null,"title":"LIVE: Noel Leeming - Vendor KPIs > Performance Table","owner":{"id":"8c12bab1432233fa","login":"gfk-displayr-eng","name":"GfK Displayr Engineering"}},"stars":1,"starred":false,"owner":{"type":"team","id":"8c12bab1432233fa","login":"gfk-displayr-eng","name":"GfK Displayr Engineering","avatar_url":"https://avatars-next.observableusercontent.com/1892c62d3af77b29e59be03cc9cf987ec074cf236e9dbf9d0339195e3382023d","tier":"starter_2024"},"version":936,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fce691ad641db246","login":"karelschwarz","name":"Karel Schwarz","avatar_url":"https://avatars-next.observableusercontent.com/41df4c4d08c9242919771d7dd8d9f42b7043420527ff819661d1f19dc7b11bdc","tier":null}],"members":[{"type":"team","id":"8c12bab1432233fa","login":"gfk-displayr-eng","name":"GfK Displayr Engineering","avatar_url":"https://avatars-next.observableusercontent.com/1892c62d3af77b29e59be03cc9cf987ec074cf236e9dbf9d0339195e3382023d","tier":"starter_2024","role":"editor"},{"type":"individual","id":"fce691ad641db246","login":"karelschwarz","name":"Karel Schwarz","avatar_url":"https://avatars-next.observableusercontent.com/41df4c4d08c9242919771d7dd8d9f42b7043420527ff819661d1f19dc7b11bdc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":5,"collection":null,"type":"notebook","body":{"title":"","cells":[{"id":341,"value":"Noel Leeming - Vendor KPIs > Category Leaderboard","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":683,"value":"viewof SwitchButtons = Inputs.radio([\"Revenue\", \"Quantity\"], {label: \"Switch\", value: \"Revenue\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":560,"value":"mainDisplayrTable = html`

${forDisplayr}

`\n//now you're good\n//I would delete all the unnecessary / unused cells\n//otherwise will cause confusion \n//fully agree :) thanks! I have a depression from what I saw :)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"forDisplayr = Inputs.table(\n data_absolutes,//DTU, \n {\n columns: columnToShow,\n rows: 30,\n format: tableFormatsSplit,\n align: tableColumnAlignments,\n layout: \"fixed\"\n}) \n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"DTU = {\n let tempvar3 = dataToUse\n for (let i = 0; i < tempvar3.length; i++) {\n tempvar3[i].PG = tempvar3[i].PG.replace('REVENUE ','').replace('QUANTITY ','')\n } \n return tempvar3\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":832,"value":"data_absolutes = DTU.filter(o => o._row.indexOf(\"%\") == -1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":838,"value":"data_relatives = DTU.filter(o => o._row.indexOf(\"%\") > -1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"kpis = dataToUse.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":852,"value":"kpis_absolute = data_absolutes.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":847,"value":"kpis_relative = data_relatives.map(o => o[firstColRename])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":857,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":914,"value":"function col1FormtterSplit(colName) { \n return (x,i) => { \n const y = data_relatives[i][colName]\n \n return htl.html`

${(x)}
${y}

` \n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"\ntableFormats = Object.fromEntries(\n columnToShow.map((o) => {\n let pair = []\n if((o == firstColRename)) {\n pair = [o, x => x]\n }\n else {\n pair = [o, cellFormatter()] \n }\n return pair\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":863,"value":"tableFormatsSplit = Object.fromEntries(\n columnToShow.map((o) => {\n let pair = []\n if((o == firstColRename)) {\n pair = [o, col1FormtterSplit(o)]\n }\n else {\n pair = [o, cellFormatterSplit(o)] \n }\n return pair\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"tableColumnAlignments = Object.fromEntries(columnToShow.map( (o,i) => [o, i==0?\"left\":\"right\"] ))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"dataToUse = \n{\n let tempvar = dataToUse2\n if(SwitchButtons == 'Revenue') {\n tempvar = dataToUse2.filter(item => item._row.indexOf('REVENUE') > -1)\n } else if (SwitchButtons == \"Quantity\") {\n tempvar = dataToUse2.filter(item => item._row.indexOf('QUANTITY') > -1)\n } \n return tempvar\n}\n\n\n \n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"dataToUse2 = dataMockDisplayr.data.map(o => {\n const renamedObj = {} \n renamedObj[firstColRename] = o._row\n return {\n ...renamedObj,\n ...o\n }\n})\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"columnToShow = { \n let columnsAll = [firstColRename].concat(Object.keys(dataMockDisplayr.data[0])) //Add Brand\n columnsAll.splice(columnsAll.length - 1,1) ///get rid of _.row\n return columnsAll\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"firstColRename = \"PG\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 31:"$30:body"