Published
Edited
May 13, 2020
md`# Companies / Tasks by Group ${aggr==="m"?"This Month":aggr==="ytd"?"This Year":"Fiscal 2020"}`
html`<ul>${groups.map(g => `<li> ${g.count} ${g.name} (${g.tasks} tasks)</li>`)}</ul>`
viewof aggr = html`<select>
<option>m
<option>ytd
<option>fy
</select>`
viewof field = html`<select>
<option>tasks
<option>count
</select>`
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();
}
groups = Object.keys(group).map(c=>group[c]).sort((a,b)=>a.count>b.count?-1:1)
total = Object.keys(group).reduce((a,c) => {
const g = group[c];
a.count += g.count;
a.tasks += g.tasks;
return a;
},{count:0,tasks:0})
group = tasks.reduce((a,t) => {
const v = (a[t.parent]||(a[t.parent] = {name: t.parent, tasks:0, count:0}));
v.tasks += t[aggr];
if (t[aggr]) {
v.count++;
}
return a;
}, {});
d3=require("d3@5")
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
}
]
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
