30:T572,chart = { const height = width / 2; const margin = height / 10; const radius = Math.min(width, height) / 2 - margin const color = d3.scaleOrdinal() .domain(groups.map(g=>g.name)) .range(d3.schemeDark2); const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]); const g = svg.append("g") .attr("transform", "translate(" + width / 2 + "," + height / 2 + ")"); var arcGenerator = d3.arc() .innerRadius(0) .outerRadius(radius) function update(data) { var pie = d3.pie() .value(function(d) { return d[field]; }) .sort(function(a, b) { return d3.ascending(a[field], b[field]);} ) var data_ready = pie(data) var u = g.selectAll("path") .data(data_ready) u .enter() .append('path') .merge(u) .transition() .duration(1000) .attr('d', d3.arc() .innerRadius(0) .outerRadius(radius) ) .attr('fill', function(d){ return(color(d.data.name)) }) .attr("stroke", "white") .style("stroke-width", "2px") .style("opacity", 1) u .enter() .append('text') .text(function(d){ return d.data.name}) .attr("transform", function(d) { return "translate(" + arcGenerator.centroid(d) + ")"; }) .style("text-anchor", "middle") .style("font-size", 6) u.exit().remove() } update(groups); return svg.node(); }31:T8add,tasks = [ { "name": "VOSTA-Stahlhandel GmbH", "parent": "ASG Business Applications", "fy": 67, "m": 67, "ytd": 67 }, { "name": "Tigre", "parent": "CMS Brazil", "fy": 1386, "m": 227, "ytd": 780 }, { "name": "Kleineberg GmbH", "parent": "ASG Business Applications", "fy": 38, "m": 38, "ytd": 38 }, { "name": "IBB", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "Rubin Mühle GmbH", "parent": "ASG Business Applications", "fy": 31, "m": 31, "ytd": 31 }, { "name": "Aviva", "parent": "TELUS", "fy": 1407, "m": 175, "ytd": 710 }, { "name": "OVE01-R2", "parent": "TELUS", "fy": 1087, "m": 123, "ytd": 409 }, { "name": "Dometic Germany Krautheim GmbH", "parent": "ASG Business Applications", "fy": 165, "m": 165, "ytd": 165 }, { "name": "bio-familia", "parent": "ASG Business Applications", "fy": 4, "m": 0, "ytd": 1 }, { "name": "Wünsche", "parent": "ASG Business Applications", "fy": 9, "m": 2, "ytd": 8 }, { "name": "Filltech GmbH | Gas Filling Solutions", "parent": "ASG Business Applications", "fy": 36, "m": 36, "ytd": 36 }, { "name": "PSO SSRS Mobile Reporting", "parent": "AMAP", "fy": 33, "m": 5, "ytd": 12 }, { "name": "Komax", "parent": "ASG Business Applications", "fy": 20, "m": 1, "ytd": 7 }, { "name": "CMS RPA", "parent": "CMS", "fy": 64, "m": 40, "ytd": 64 }, { "name": "Richard Fritz Holding GmbH", "parent": "ASG Business Applications", "fy": 87, "m": 87, "ytd": 87 }, { "name": "Concert Properties", "parent": "TELUS", "fy": 967, "m": 109, "ytd": 386 }, { "name": "Ohly", "parent": "ASG Business Applications", "fy": 23, "m": 0, "ytd": 11 }, { "name": "SABAG Biel/Bienne Stahlcenter", "parent": "ASG Business Applications", "fy": 41, "m": 41, "ytd": 41 }, { "name": "Scott Builders", "parent": "TELUS", "fy": 558, "m": 89, "ytd": 307 }, { "name": "Kuchen-Peter", "parent": "ASG Business Applications", "fy": 4, "m": 0, "ytd": 1 }, { "name": "Stanwell", "parent": "AMAP", "fy": 794, "m": 102, "ytd": 329 }, { "name": "UK POI", "parent": "AMAP", "fy": 4702, "m": 536, "ytd": 2257 }, { "name": "OMICRON electronics Gmbh", "parent": "ASG Business Applications", "fy": 32, "m": 6, "ytd": 32 }, { "name": "Prospera Credit Union", "parent": "TELUS", "fy": 1206, "m": 241, "ytd": 668 }, { "name": "UNIFERM GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 36, "m": 2, "ytd": 22 }, { "name": "TWE", "parent": "AMAP", "fy": 3408, "m": 396, "ytd": 1912 }, { "name": "NHS O365", "parent": "CMS", "fy": 187, "m": 100, "ytd": 158 }, { "name": "Trans Mountain", "parent": "CMS D365", "fy": 70, "m": 22, "ytd": 70 }, { "name": "4B Fenster", "parent": "ASG Business Applications", "fy": 30, "m": 0, "ytd": 0 }, { "name": "CDC", "parent": "CMS", "fy": 2328, "m": 335, "ytd": 1141 }, { "name": "Syneos Health", "parent": "CMS", "fy": 578, "m": 46, "ytd": 250 }, { "name": "Gavi", "parent": "ASG Business Applications", "fy": 20, "m": 0, "ytd": 0 }, { "name": "Jansen", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 6 }, { "name": "MetPolice", "parent": "AOS", "fy": 64, "m": 18, "ytd": 51 }, { "name": "Solotech AMS", "parent": "CMS D365", "fy": 71, "m": 15, "ytd": 71 }, { "name": "zur Rose Pharma", "parent": "ASG Business Applications", "fy": 13, "m": 5, "ytd": 10 }, { "name": "Rutishauser Weinkellerei AG", "parent": "ASG Business Applications", "fy": 17, "m": 17, "ytd": 17 }, { "name": "Tullow", "parent": "AOS", "fy": 1576, "m": 147, "ytd": 817 }, { "name": "Metrohm", "parent": "ASG Business Applications", "fy": 12, "m": 5, "ytd": 6 }, { "name": "Superior Industries Europe AG", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 0 }, { "name": "TIM", "parent": "CMS Brazil", "fy": 1590, "m": 285, "ytd": 1038 }, { "name": "Wiha Werkzeuge GmbH", "parent": "ASG Business Applications", "fy": 22, "m": 0, "ytd": 10 }, { "name": "Plaston CR", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "Avanade Validation Tenant R2 Test", "parent": "TELUS", "fy": 3, "m": 2, "ytd": 3 }, { "name": "Comgás", "parent": "CMS Brazil", "fy": 329, "m": 60, "ytd": 281 }, { "name": "MICRONEL", "parent": "ASG Business Applications", "fy": 21, "m": 3, "ytd": 10 }, { "name": "United Utilities", "parent": "CMS", "fy": 100, "m": 13, "ytd": 53 }, { "name": "Seattle Goodwill Industries", "parent": "CMS D365", "fy": 46, "m": 0, "ytd": 20 }, { "name": "At Speed", "parent": "AMAP", "fy": 15, "m": 0, "ytd": 0 }, { "name": "K + D", "parent": "ASG Business Applications", "fy": 4, "m": 1, "ytd": 2 }, { "name": "NYP", "parent": "CMS", "fy": 1676, "m": 202, "ytd": 520 }, { "name": "Expeditors", "parent": "CMS", "fy": 2977, "m": 373, "ytd": 1345 }, { "name": "FRIKE", "parent": "ASG Business Applications", "fy": 13, "m": 0, "ytd": 10 }, { "name": "Bombril BPO", "parent": "CMS Brazil", "fy": 109, "m": 18, "ytd": 84 }, { "name": "DCS - CMS", "parent": "CMS", "fy": 10, "m": 1, "ytd": 7 }, { "name": "Flex", "parent": "ASG Business Applications", "fy": 66, "m": 12, "ytd": 40 }, { "name": "Nokia - SaaS ACC", "parent": "CMS Brazil", "fy": 296, "m": 94, "ytd": 265 }, { "name": "Miebach", "parent": "ASG Business Applications", "fy": 20, "m": 1, "ytd": 12 }, { "name": "ATMS", "parent": "CMS", "fy": 10, "m": 1, "ytd": 4 }, { "name": "DNV GL", "parent": "AMAP", "fy": 1687, "m": 204, "ytd": 804 }, { "name": "Bergader", "parent": "ASG Business Applications", "fy": 7, "m": 2, "ytd": 3 }, { "name": "Hostettler", "parent": "ASG Business Applications", "fy": 169, "m": 21, "ytd": 73 }, { "name": "satek", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "Bellaflora", "parent": "ASG Business Applications", "fy": 174, "m": 26, "ytd": 109 }, { "name": "SQM International", "parent": "D365", "fy": 248, "m": 62, "ytd": 175 }, { "name": "Viessmann Elektronik GmbH", "parent": "ASG Business Applications", "fy": 5, "m": 5, "ytd": 5 }, { "name": "VITRONIC Dr.-Ing. Stein Bildverarbeitungssysteme GmbH", "parent": "ASG Business Applications", "fy": 21, "m": 21, "ytd": 21 }, { "name": "JBS", "parent": "CMS Brazil", "fy": 243, "m": 27, "ytd": 156 }, { "name": "REGO-FIX", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "NEXT", "parent": "CMS Brazil", "fy": 1, "m": 0, "ytd": 1 }, { "name": "Tervita", "parent": "TELUS", "fy": 1178, "m": 115, "ytd": 672 }, { "name": "ALUKON KG Haigerloch", "parent": "ASG Business Applications", "fy": 53, "m": 53, "ytd": 53 }, { "name": "Monsanto", "parent": "CMS Brazil", "fy": 376, "m": 92, "ytd": 297 }, { "name": "ECO Schulte", "parent": "ASG Business Applications", "fy": 11, "m": 0, "ytd": 0 }, { "name": "Walter", "parent": "ASG Business Applications", "fy": 3, "m": 0, "ytd": 0 }, { "name": "Promena", "parent": "ASG Business Applications", "fy": 24, "m": 1, "ytd": 6 }, { "name": "Gates Mectrol GmbH", "parent": "ASG Business Applications", "fy": 3, "m": 0, "ytd": 0 }, { "name": "Vario Edelstahl AG", "parent": "ASG Business Applications", "fy": 39, "m": 39, "ytd": 39 }, { "name": "Dauphin", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "TELUS", "parent": "CMS", "fy": 563, "m": 49, "ytd": 226 }, { "name": "Neoss", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "Haag-Streit", "parent": "ASG Business Applications", "fy": 75, "m": 11, "ytd": 38 }, { "name": "PCLI", "parent": "DMMS", "fy": 451, "m": 75, "ytd": 273 }, { "name": "Ache", "parent": "CMS Brazil", "fy": 664, "m": 261, "ytd": 369 }, { "name": "Vivere", "parent": "CMS Brazil", "fy": 2108, "m": 435, "ytd": 1429 }, { "name": "H. Weber", "parent": "ASG Business Applications", "fy": 370, "m": 14, "ytd": 127 }, { "name": "Connect First Credit Union", "parent": "TELUS", "fy": 2732, "m": 237, "ytd": 1145 }, { "name": "TOPSTAR", "parent": "ASG Business Applications", "fy": 7, "m": 0, "ytd": 1 }, { "name": "baier & michels GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 256, "m": 256, "ytd": 256 }, { "name": "CUPE", "parent": "TELUS", "fy": 2769, "m": 104, "ytd": 1071 }, { "name": "ACN SSRS Mobile Reporting", "parent": "AMAP", "fy": 12, "m": 2, "ytd": 12 }, { "name": "Hans Segmüller", "parent": "ASG Business Applications", "fy": 5, "m": 0, "ytd": 1 }, { "name": "Aliments Ultima", "parent": "TELUS", "fy": 85, "m": 10, "ytd": 45 }, { "name": "M.K. Computer ELECTRONIC GmbH", "parent": "ASG Business Applications", "fy": 15, "m": 15, "ytd": 15 }, { "name": "Sony Pictures", "parent": "CMS D365", "fy": 52, "m": 16, "ytd": 52 }, { "name": "Schmelzmetall", "parent": "ASG Business Applications", "fy": 26, "m": 0, "ytd": 12 }, { "name": "Deltamess", "parent": "ASG Business Applications", "fy": 3, "m": 0, "ytd": 0 }, { "name": "Daimler", "parent": "ASG Business Applications", "fy": 27, "m": 0, "ytd": 0 }, { "name": "Dolder", "parent": "ASG Business Applications", "fy": 41, "m": 3, "ytd": 18 }, { "name": "BIBUS AG", "parent": "ASG Business Applications", "fy": 4, "m": 4, "ytd": 4 }, { "name": "Greenbrier", "parent": "CMS", "fy": 468, "m": 95, "ytd": 441 }, { "name": "WEC Energy Group", "parent": "CMS", "fy": 178, "m": 11, "ytd": 80 }, { "name": "GTE Industrieelektronik GmbH", "parent": "ASG Business Applications", "fy": 18, "m": 18, "ytd": 18 }, { "name": "BRF", "parent": "CMS Brazil", "fy": 321, "m": 123, "ytd": 321 }, { "name": "Mansfield", "parent": "D365", "fy": 323, "m": 67, "ytd": 197 }, { "name": "Medela AG", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 3 }, { "name": "Trisa Holding", "parent": "ASG Business Applications", "fy": 18, "m": 2, "ytd": 7 }, { "name": "Exxon Mobil", "parent": "AMAP", "fy": 833, "m": 7, "ytd": 241 }, { "name": "eurotrade Flughafen München Handels-GmbH", "parent": "ASG Business Applications", "fy": 23, "m": 11, "ytd": 23 }, { "name": "TELUS Tenant Skype Marketing", "parent": "TELUS", "fy": 154, "m": 16, "ytd": 81 }, { "name": "Kundert", "parent": "ASG Business Applications", "fy": 4, "m": 0, "ytd": 0 }, { "name": "Beilharz GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 2, "m": 2, "ytd": 2 }, { "name": "Filtrox", "parent": "ASG Business Applications", "fy": 15, "m": 1, "ytd": 4 }, { "name": "Glatfelter", "parent": "ASG Business Applications", "fy": 5, "m": 0, "ytd": 3 }, { "name": "FÜR SIE Handelsgenossenschaft eG", "parent": "ASG Business Applications", "fy": 15, "m": 15, "ytd": 15 }, { "name": "SBB GmbH", "parent": "ASG Business Applications", "fy": 80, "m": 80, "ytd": 80 }, { "name": "Stadt Frankfurt", "parent": "ASG Business Applications", "fy": 50, "m": 1, "ytd": 21 }, { "name": "Pandurata", "parent": "CMS Brazil", "fy": 45, "m": 4, "ytd": 28 }, { "name": "Enwave", "parent": "D365", "fy": 815, "m": 88, "ytd": 369 }, { "name": "Limeco AG", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "Blum-Novotest GmbH", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "Brechmann Handels GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "Hempel Special Metals AG", "parent": "ASG Business Applications", "fy": 116, "m": 116, "ytd": 116 }, { "name": "NavVis GmbH", "parent": "ASG Business Applications", "fy": 5, "m": 5, "ytd": 5 }, { "name": "Burg Design", "parent": "ASG Business Applications", "fy": 6, "m": 1, "ytd": 2 }, { "name": "Büttenpapierfabrik Gmund GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 7, "m": 7, "ytd": 7 }, { "name": "AQA", "parent": "CMS", "fy": 5, "m": 1, "ytd": 4 }, { "name": "SHG Rolladen-Systeme GmbH", "parent": "ASG Business Applications", "fy": 42, "m": 42, "ytd": 42 }, { "name": "Plaston", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 4 }, { "name": "SABAG Luzern", "parent": "ASG Business Applications", "fy": 29, "m": 7, "ytd": 12 }, { "name": "Notz Metall AG", "parent": "ASG Business Applications", "fy": 177, "m": 177, "ytd": 177 }, { "name": "Roster", "parent": "CMS Brazil", "fy": 170, "m": 54, "ytd": 122 }, { "name": "OI", "parent": "CMS Brazil", "fy": 483, "m": 99, "ytd": 450 }, { "name": "Mathematica", "parent": "CMS", "fy": 344, "m": 62, "ytd": 211 }, { "name": "TELUS Tenant Skype OVE", "parent": "TELUS", "fy": 52, "m": 0, "ytd": 12 }, { "name": "Santander Rio", "parent": "CMS Brazil", "fy": 1836, "m": 422, "ytd": 1300 }, { "name": "Früh", "parent": "ASG Business Applications", "fy": 8, "m": 0, "ytd": 8 }, { "name": "ALANOD GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 24, "m": 24, "ytd": 24 }, { "name": "E+H", "parent": "ASG Business Applications", "fy": 71, "m": 3, "ytd": 40 }, { "name": "All Weather Windows", "parent": "TELUS", "fy": 606, "m": 45, "ytd": 372 }, { "name": "Pühl GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 75, "m": 75, "ytd": 75 }, { "name": "C. Beerli", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 1 }, { "name": "STEICO", "parent": "ASG Business Applications", "fy": 64, "m": 5, "ytd": 32 }, { "name": "National Grid - ICE", "parent": "CMS", "fy": 9136, "m": 673, "ytd": 3588 }, { "name": "SI Systems", "parent": "TELUS", "fy": 794, "m": 99, "ytd": 587 }, { "name": "dSPACE", "parent": "ASG Business Applications", "fy": 53, "m": 9, "ytd": 37 }, { "name": "OVE02-R2", "parent": "TELUS", "fy": 459, "m": 74, "ytd": 215 }, { "name": "comepack GmbH", "parent": "ASG Business Applications", "fy": 74, "m": 74, "ytd": 74 }, { "name": "PPC AMP", "parent": "CMS", "fy": 152, "m": 33, "ytd": 85 }, { "name": "Intesia Group Holding GmbH", "parent": "ASG Business Applications", "fy": 9, "m": 9, "ytd": 9 }, { "name": "Home Art", "parent": "ASG Business Applications", "fy": 43, "m": 5, "ytd": 26 }, { "name": "Gibson Energy", "parent": "D365", "fy": 48, "m": 4, "ytd": 30 }, { "name": "BVS", "parent": "ASG Business Applications", "fy": 3, "m": 2, "ytd": 2 }, { "name": "Keller Grundbau", "parent": "ASG Business Applications", "fy": 18, "m": 0, "ytd": 5 }, { "name": "Elma Electronic", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "Essmann", "parent": "ASG Business Applications", "fy": 4, "m": 0, "ytd": 0 }, { "name": "Noventa", "parent": "ASG Business Applications", "fy": 15, "m": 1, "ytd": 8 }, { "name": "Rettenmeier", "parent": "ASG Business Applications", "fy": 10, "m": 6, "ytd": 9 }, { "name": "ROLEC Gehäuse-Systeme GmbH", "parent": "ASG Business Applications", "fy": 68, "m": 68, "ytd": 68 }, { "name": "AMAP Security", "parent": "AMAP", "fy": 645, "m": 66, "ytd": 368 }, { "name": "Telefonica", "parent": "CMS Brazil", "fy": 6003, "m": 1552, "ytd": 4273 }, { "name": "National Health Service", "parent": "CMS", "fy": 15670, "m": 2206, "ytd": 8525 }, { "name": "Assima Verbund GmbH & Co KG", "parent": "ASG Business Applications", "fy": 86, "m": 86, "ytd": 86 }, { "name": "BDO", "parent": "TELUS", "fy": 7033, "m": 893, "ytd": 2756 }, { "name": "TTWork", "parent": "CMS Brazil", "fy": 691, "m": 390, "ytd": 686 }, { "name": "Dr. Hinz Dental Vertriebsgesellschaft mbH & Co. KG", "parent": "ASG Business Applications", "fy": 31, "m": 31, "ytd": 31 }, { "name": "Rollon GmbH", "parent": "ASG Business Applications", "fy": 59, "m": 59, "ytd": 59 }, { "name": "BX+", "parent": "CMS Brazil", "fy": 439, "m": 118, "ytd": 307 }, { "name": "GARDEUR GmbH", "parent": "ASG Business Applications", "fy": 3, "m": 3, "ytd": 3 }, { "name": "ITS EDW", "parent": "AMAP", "fy": 2276, "m": 281, "ytd": 1182 }, { "name": "ITS", "parent": "AMAP", "fy": 16, "m": 11, "ytd": 12 }, { "name": "Messingwerk Plettenberg Herfeld GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 88, "m": 88, "ytd": 88 }, { "name": "BONECO", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "Unilever", "parent": "CMS", "fy": 2162, "m": 253, "ytd": 1050 }, { "name": "Gebrüder Recknagel Präzisionsstahl GmbH", "parent": "ASG Business Applications", "fy": 83, "m": 83, "ytd": 83 }, { "name": "Schuller Eh´klar", "parent": "ASG Business Applications", "fy": 26, "m": 2, "ytd": 11 }, { "name": "GANTNER Electronic GmbH", "parent": "ASG Business Applications", "fy": 267, "m": 267, "ytd": 267 }, { "name": "Robert Bosch", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 1 }, { "name": "DGS", "parent": "ASG Business Applications", "fy": 35, "m": 6, "ytd": 35 }, { "name": "Eurofoam", "parent": "ASG Business Applications", "fy": 10, "m": 6, "ytd": 10 }, { "name": "Findeis GmbH", "parent": "ASG Business Applications", "fy": 16, "m": 16, "ytd": 16 }, { "name": "Santander SIM", "parent": "CMS Brazil", "fy": 1014, "m": 162, "ytd": 671 }, { "name": "Canadian Red Cross", "parent": "D365", "fy": 157, "m": 15, "ytd": 76 }, { "name": "Police Federation", "parent": "AOS", "fy": 197, "m": 52, "ytd": 177 }, { "name": "BV Financeira", "parent": "CMS Brazil", "fy": 1788, "m": 440, "ytd": 1538 }, { "name": "M. Juergensen GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 39, "m": 4, "ytd": 16 }, { "name": "Natures Path", "parent": "TELUS", "fy": 536, "m": 91, "ytd": 283 }, { "name": "Pioneer DJ", "parent": "DMMS", "fy": 365, "m": 40, "ytd": 215 }, { "name": "VIA Rail", "parent": "TELUS", "fy": 7024, "m": 243, "ytd": 6634 }, { "name": "IRC", "parent": "CMS D365", "fy": 27, "m": 27, "ytd": 27 }, { "name": "zur Rose Suisse", "parent": "ASG Business Applications", "fy": 25, "m": 3, "ytd": 11 }, { "name": "OTPP", "parent": "CMS", "fy": 1236, "m": 45, "ytd": 448 }, { "name": "sia Abrasives", "parent": "ASG Business Applications", "fy": 113, "m": 8, "ytd": 68 }, { "name": "AC-Motoren GmbH", "parent": "ASG Business Applications", "fy": 274, "m": 274, "ytd": 274 }, { "name": "BRAINPOOL TV GmbH", "parent": "ASG Business Applications", "fy": 26, "m": 26, "ytd": 26 }, { "name": "Germete", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 3 }, { "name": "LATAM", "parent": "CMS Brazil", "fy": 546, "m": 141, "ytd": 354 }, { "name": "Chal-Tec GmbH", "parent": "ASG Business Applications", "fy": 59, "m": 59, "ytd": 59 }, { "name": "Alber GmbH", "parent": "ASG Business Applications", "fy": 239, "m": 239, "ytd": 239 }, { "name": "HSBC-MIP", "parent": "AOS", "fy": 1287, "m": 73, "ytd": 814 }, { "name": "Egger Getränke", "parent": "ASG Business Applications", "fy": 18, "m": 1, "ytd": 8 }, { "name": "PSS Interservice", "parent": "ASG Business Applications", "fy": 1, "m": 0, "ytd": 0 }, { "name": "Hoesch Metallurgie GmbH", "parent": "ASG Business Applications", "fy": 7, "m": 7, "ytd": 7 }, { "name": "Wagner", "parent": "ASG Business Applications", "fy": 14, "m": 3, "ytd": 9 }, { "name": "Herba-Imodac", "parent": "ASG Business Applications", "fy": 3, "m": 1, "ytd": 2 }, { "name": "AMAP Shared Infra", "parent": "AMAP", "fy": 981, "m": 136, "ytd": 573 }, { "name": "Hamilton Bonaduz AG", "parent": "ASG Business Applications", "fy": 34, "m": 6, "ytd": 32 }, { "name": "HUBER SE", "parent": "ASG Business Applications", "fy": 2, "m": 2, "ytd": 2 }, { "name": "Kabelwerk Rhenania GmbH", "parent": "ASG Business Applications", "fy": 10, "m": 10, "ytd": 10 }, { "name": "B+B Thermo-Technik GmbH", "parent": "ASG Business Applications", "fy": 56, "m": 56, "ytd": 56 }, { "name": "Encory GmbH", "parent": "ASG Business Applications", "fy": 89, "m": 2, "ytd": 36 }, { "name": "Hauff-Technik GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 2, "m": 0, "ytd": 2 }, { "name": "AMAP Managed Services All Clients", "parent": "AMAP", "fy": 408, "m": 55, "ytd": 230 }, { "name": "Laufenberg GmbH", "parent": "ASG Business Applications", "fy": 20, "m": 20, "ytd": 20 }, { "name": "ITS Collab", "parent": "AMAP", "fy": 192, "m": 5, "ytd": 102 }, { "name": "Brookfield", "parent": "D365", "fy": 6523, "m": 1242, "ytd": 3833 }, { "name": "Microsoft CSP", "parent": "CMS", "fy": 46, "m": 46, "ytd": 46 }, { "name": "National Grid", "parent": "CMS", "fy": 28299, "m": 2889, "ytd": 12627 }, { "name": "Swiss Krono", "parent": "ASG Business Applications", "fy": 10, "m": 1, "ytd": 5 }, { "name": "WEPA Apothekenbedarf GmbH & Co KG", "parent": "ASG Business Applications", "fy": 317, "m": 317, "ytd": 317 }, { "name": "Bombril SAP", "parent": "CMS Brazil", "fy": 345, "m": 82, "ytd": 164 }, { "name": "Northwest Fiber", "parent": "CMS Microsoft CSP", "fy": 8, "m": 2, "ytd": 8 }, { "name": "Avanade Validation Tenant", "parent": "TELUS", "fy": 24, "m": 0, "ytd": 12 }, { "name": "Anbima", "parent": "CMS Brazil", "fy": 786, "m": 184, "ytd": 555 }, { "name": "SFM-Cosmos", "parent": "ASG Business Applications", "fy": 2, "m": 2, "ytd": 2 }, { "name": "BeVo N.V.", "parent": "ASG Business Applications", "fy": 34, "m": 34, "ytd": 34 }, { "name": "Tomlinson", "parent": "TELUS", "fy": 656, "m": 190, "ytd": 465 }, { "name": "Trigress Armaturen", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 3 }, { "name": "G.O. Carlson", "parent": "CMS", "fy": 313, "m": 8, "ytd": 116 }, { "name": "MAILER STAHL GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 2, "m": 2, "ytd": 2 }, { "name": "Max Weishaupt GmbH", "parent": "ASG Business Applications", "fy": 153, "m": 153, "ytd": 153 }, { "name": "ITS AEAP", "parent": "AMAP", "fy": 987, "m": 128, "ytd": 518 }, { "name": "Kählig", "parent": "ASG Business Applications", "fy": 6, "m": 2, "ytd": 3 }, { "name": "Ruch Novaplast GmbH & Co.KG", "parent": "ASG Business Applications", "fy": 6, "m": 0, "ytd": 3 }, { "name": "H&R Block Canada", "parent": "TELUS", "fy": 1093, "m": 70, "ytd": 480 }, { "name": "Herz GmbH", "parent": "ASG Business Applications", "fy": 3, "m": 3, "ytd": 3 }, { "name": "MMEC Mannesmann GmbH", "parent": "ASG Business Applications", "fy": 104, "m": 104, "ytd": 104 }, { "name": "Hebgo AG", "parent": "ASG Business Applications", "fy": 4, "m": 0, "ytd": 2 }, { "name": "Fritz Landolt", "parent": "ASG Business Applications", "fy": 5, "m": 0, "ytd": 3 }, { "name": "ITS AIM", "parent": "AMAP", "fy": 510, "m": 50, "ytd": 232 }, { "name": "Storch-Ciret Business Services GmbH", "parent": "ASG Business Applications", "fy": 147, "m": 147, "ytd": 147 }, { "name": "NHS O365 Restricted", "parent": "CMS", "fy": 159, "m": 88, "ytd": 133 }, { "name": "Valencia College", "parent": "AMAP", "fy": 100, "m": 0, "ytd": 9 }, { "name": "Sony", "parent": "CMS", "fy": 2709, "m": 175, "ytd": 658 }, { "name": "Compounds", "parent": "ASG Business Applications", "fy": 54, "m": 7, "ytd": 29 }, { "name": "Steinfels Swiss", "parent": "ASG Business Applications", "fy": 7, "m": 0, "ytd": 6 }, { "name": "IMS Verbindungstechnik GmbH & Co. KG", "parent": "ASG Business Applications", "fy": 29, "m": 29, "ytd": 29 }, { "name": "Aluplast GmbH", "parent": "ASG Business Applications", "fy": 11, "m": 0, "ytd": 0 }, { "name": "Paravan GmbH", "parent": "ASG Business Applications", "fy": 47, "m": 47, "ytd": 47 }, { "name": "EBL", "parent": "ASG Business Applications", "fy": 11, "m": 0, "ytd": 11 }, { "name": "Santander Mexico", "parent": "CMS Brazil", "fy": 930, "m": 158, "ytd": 662 }, { "name": "Pattern Energy Group", "parent": "CMS D365", "fy": 47, "m": 16, "ytd": 41 }, { "name": "Avaya", "parent": "CMS", "fy": 1489, "m": 120, "ytd": 623 }, { "name": "L'Oreal", "parent": "AMAP", "fy": 132, "m": 1, "ytd": 14 }, { "name": "PRO.Facility Solution GmbH", "parent": "ASG Business Applications", "fy": 2, "m": 2, "ytd": 2 }, { "name": "ADLON Intelligent Solutions GmbH", "parent": "ASG Business Applications", "fy": 10, "m": 10, "ytd": 10 } ] 32:[] 2e:{"title":"Companies / Tasks by Group Fiscal 2020","cells":[{"id":0,"value":"md`# Companies / Tasks by Group ${aggr===\"m\"?\"This Month\":aggr===\"ytd\"?\"This Year\":\"Fiscal 2020\"}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"html`

${g.count} ${g.name} (${g.tasks} tasks)

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"viewof aggr = html``","pinned":true,"hidden":false,"mode":"ojs"},{"id":82,"value":"viewof field = html``","pinned":true,"hidden":false,"mode":"ojs"},{"id":70,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":34,"value":"groups = Object.keys(group).map(c=>group[c]).sort((a,b)=>a.count>b.count?-1:1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"total = Object.keys(group).reduce((a,c) => {\n const g = group[c];\n a.count += g.count;\n a.tasks += g.tasks; \n return a;\n},{count:0,tasks:0})","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"group = tasks.reduce((a,t) => {\n const v = (a[t.parent]||(a[t.parent] = {name: t.parent, tasks:0, count:0}));\n v.tasks += t[aggr];\n if (t[aggr]) {\n v.count++;\n }\n return a;\n}, {});","pinned":true,"hidden":false,"mode":"ojs"},{"id":68,"value":"d3=require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":2,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}