Skip to content

Instantly share code, notes, and snippets.

@fproperzi

fproperzi/afGroupBy2TreeMapArray

Last active April 27, 2023 07:49
Show Gist options
  • Save fproperzi/5dd2e92e95ed75e284d9820b66da974f to your computer and use it in GitHub Desktop.
Save fproperzi/5dd2e92e95ed75e284d9820b66da974f to your computer and use it in GitHub Desktop.
Download ZIP
From sql group-by flat array to google chart treeMap data
Raw
afGroupBy2TreeMapArray
// main function
function afGroupBy2TreeMapArray(data, global='ciccio') {
let id = 1,
arr = data //create tree from flat array
.reduce((a, r) => {
let keys = Object.keys(r);
keys.reduce(function (q, k, i) {
const f = r[k];
if (!q[f]) q._.push([{f:f, v:String(id++), k:k, level:i, childs:(q[f] = { _: [] })._} ]);
return q[f];
}, a);
return a;
}, { _: [] })
._;
let art = [["node","parent","count"],[global,null,0]],
stopLevel = Object.keys(data[0]).length-2; //3
bbuild = (arz,parent) => { // build array ready for arrayToDataTable treeMap
arz.forEach(r=>
r.forEach(j=>{
let c = 0, node = { f:j.f, v:j.v, k:j.k };
if(j.level != stopLevel) {
node.f = node.k +': '+ node.f;
bbuild(j.childs, node);
}
else {
c = j.childs[0][0].f;
}
art.push([node, parent, c]);
//console.log([node, parent, c, j.level]);
})
)
};
bbuild(arr, global);
return art;
}
// from sql group by:
// SELECT concat(ffile, ' (', uuid, ')') ffile, magazzino, tipo, coalesce(cesta,'#NULL') cesta, count(*) cnt FROM t_uploaded_xlsx group by ffile,uuid,magazzino,tipo,cesta
var data = [
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"1A","cnt":517},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"2A","cnt":2662},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"3A","cnt":2136},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"4A","cnt":1177},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"5A","cnt":5247},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"6A","cnt":5367},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"7A","cnt":2589},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"#N/A","cnt":10903},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"8A","cnt":495},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"9A","cnt":1111},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"10A","cnt":1494},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"11A","cnt":298},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"12A","cnt":290},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"13A","cnt":121},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"14A","cnt":4412},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"15A","cnt":5481},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"16A","cnt":3744},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"17A","cnt":174},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"18A","cnt":77},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"19A","cnt":1101},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"20A","cnt":867},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"21A","cnt":360},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"22A","cnt":3787},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"23A","cnt":5266},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"24A","cnt":3802},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"25A","cnt":5103},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"27A","cnt":121},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"28A","cnt":93},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"26A","cnt":743},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"29A","cnt":1736},
{"ffile":"PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","magazzino":"IC25","tipo":"01","cesta":"30A","cnt":3539},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"18B","cnt":201},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"19B","cnt":237},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"20B","cnt":252},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"21B","cnt":46},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"22B","cnt":1172},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"23B","cnt":1745},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"24B","cnt":1544},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"25B","cnt":1685},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"#N/A","cnt":14982},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"1B","cnt":3092},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"2B","cnt":1229},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"3B","cnt":2797},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"4B","cnt":2727},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"5B","cnt":798},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"6B","cnt":12598},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"7B","cnt":8555},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"8B","cnt":9600},
{"ffile":"DIVISIONE IC25 RESI 01.xlsx (9c17eed1-0bd9-4042-b114-405a02c6d4c7)","magazzino":"IC25","tipo":"02","cesta":"8B","cnt":11},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"9B","cnt":7809},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"10B","cnt":413},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"11B","cnt":316},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"12B","cnt":702},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"13B","cnt":3317},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"14B","cnt":2627},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"15B","cnt":2530},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"16B","cnt":2275},
{"ffile":"PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","magazzino":"IC25","tipo":"02","cesta":"17B","cnt":1921},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"#N/A","cnt":5272},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"7U","cnt":903},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"1U","cnt":444},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"2U","cnt":3495},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"3U","cnt":1178},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"4U","cnt":1441},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"5U","cnt":1240},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"06","cesta":"6U","cnt":943},
{"ffile":"PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","magazzino":"IC25","tipo":"0Y","cesta":"#N/A","cnt":4393}
];
var global = 'global';
var art = afGroupBy2TreeMapArray(data, global);
google.charts.load('current', {'packages':['treemap']});
google.charts.setOnLoadCallback(function(){
var arz = google.visualization.arrayToDataTable( art );
gtree = new google.visualization.TreeMap(document.getElementById('chart_div'));
gtree.draw(arz, {
//Enablehighlight :true,
//headerHeight: 20,
highlightOnMouseOver: true,
maxDepth: 3,
fontColor: 'black',
fontSize: 16,
height: 300,
bold:true,
showScale: false,
draggableCursor: 'pointer',
generateTooltip: function (r, size, value) {
let v0 = arz.getValue(r,0), f0 = arz.getFormattedValue(r,0), k0 = arz.Wf[r]?.c[0]?.k;
let v1 = arz.getValue(r,1), f1 = arz.getFormattedValue(r,1), k1 = arz.Wf[r]?.c[1]?.k;
return `<div style="background:#fd9; padding:10px; border-style:solid">
${ f1??global }, <b>${ (f0?.indexOf(k0) == -1 ? k0+': '+f0:f0) }</b>
<br>${ arz.getColumnLabel(2) }: ${size}
</div>`;
}
});
/** result:
[["node","parent","count"],
["global",null,0],
[{"f": "1A","v": "4","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},517],
[{"f": "2A","v": "6","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},2662],
[{"f": "3A","v": "8","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},2136],
[{"f": "4A","v": "10","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},1177],
[{"f": "5A","v": "12","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},5247],
[{"f": "6A","v": "14","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},5367],
[{"f": "7A","v": "16","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},2589],
[{"f": "#N/A","v": "18","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},10903],
[{"f": "8A","v": "20","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},495],
[{"f": "9A","v": "22","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},1111],
[{"f": "10A","v": "24","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},1494],
[{"f": "11A","v": "26","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},298],
[{"f": "12A","v": "28","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},290],
[{"f": "13A","v": "30","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},121],
[{"f": "14A","v": "32","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},4412],
[{"f": "15A","v": "34","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},5481],
[{"f": "16A","v": "36","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},3744],
[{"f": "17A","v": "38","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},174],
[{"f": "18A","v": "40","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},77],
[{"f": "19A","v": "42","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},1101],
[{"f": "20A","v": "44","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},867],
[{"f": "21A","v": "46","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},360],
[{"f": "22A","v": "48","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},3787],
[{"f": "23A","v": "50","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},5266],
[{"f": "24A","v": "52","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},3802],
[{"f": "25A","v": "54","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},5103],
[{"f": "27A","v": "56","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},121],
[{"f": "28A","v": "58","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},93],
[{"f": "26A","v": "60","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},743],
[{"f": "29A","v": "62","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},1736],
[{"f": "30A","v": "64","k": "cesta"},{"f": "tipo: 01","v": "3","k": "tipo"},3539],
[{"f": "tipo: 01","v": "3","k": "tipo"},{"f": "magazzino: IC25","v": "2","k": "magazzino"},0],
[{"f": "magazzino: IC25","v": "2","k": "magazzino"},{"f": "ffile: PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","v": "1","k": "ffile"},0],
[{"f": "ffile: PRE-DIVISIONE IC25 UCB ADULTO.xlsx (aaf3a74b-df00-405d-9c3b-7b5681f81a6d)","v": "1","k": "ffile"},"Importazioni",0],
[{"f": "18B","v": "69","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},201],
[{"f": "19B","v": "71","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},237],
[{"f": "20B","v": "73","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},252],
[{"f": "21B","v": "75","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},46],
[{"f": "22B","v": "77","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1172],
[{"f": "23B","v": "79","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1745],
[{"f": "24B","v": "81","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1544],
[{"f": "25B","v": "83","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1685],
[{"f": "#N/A","v": "85","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},14982],
[{"f": "1B","v": "87","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},3092],
[{"f": "2B","v": "89","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1229],
[{"f": "3B","v": "91","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},2797],
[{"f": "4B","v": "93","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},2727],
[{"f": "5B","v": "95","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},798],
[{"f": "6B","v": "97","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},12598],
[{"f": "7B","v": "99","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},8555],
[{"f": "8B","v": "101","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},9600],
[{"f": "9B","v": "108","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},7809],
[{"f": "10B","v": "110","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},413],
[{"f": "11B","v": "112","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},316],
[{"f": "12B","v": "114","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},702],
[{"f": "13B","v": "116","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},3317],
[{"f": "14B","v": "118","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},2627],
[{"f": "15B","v": "120","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},2530],
[{"f": "16B","v": "122","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},2275],
[{"f": "17B","v": "124","k": "cesta"},{"f": "tipo: 02","v": "68","k": "tipo"},1921],
[{"f": "tipo: 02","v": "68","k": "tipo"},{"f": "magazzino: IC25","v": "67","k": "magazzino"},0],
[{"f": "magazzino: IC25","v": "67","k": "magazzino"},{"f": "ffile: PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","v": "66","k": "ffile"},0],
[{"f": "ffile: PRE-DIVISIONE IC25 UCB BAMBINO.xlsx (bceca908-c1a2-4b62-b50e-4eeaeb3f3eef)","v": "66","k": "ffile"},"Importazioni",0],
[{"f": "8B","v": "106","k": "cesta"},{"f": "tipo: 02","v": "105","k": "tipo"},11],
[{"f": "tipo: 02","v": "105","k": "tipo"},{"f": "magazzino: IC25","v": "104","k": "magazzino"},0],
[{"f": "magazzino: IC25","v": "104","k": "magazzino"},{"f": "ffile: DIVISIONE IC25 RESI 01.xlsx (9c17eed1-0bd9-4042-b114-405a02c6d4c7)","v": "103","k": "ffile"},0],
[{"f": "ffile: DIVISIONE IC25 RESI 01.xlsx (9c17eed1-0bd9-4042-b114-405a02c6d4c7)","v": "103","k": "ffile"},"Importazioni",0],
[{"f": "#N/A","v": "129","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},5272],
[{"f": "7U","v": "131","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},903],
[{"f": "1U","v": "133","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},444],
[{"f": "2U","v": "135","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},3495],
[{"f": "3U","v": "137","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},1178],
[{"f": "4U","v": "139","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},1441],
[{"f": "5U","v": "141","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},1240],
[{"f": "6U","v": "143","k": "cesta"},{"f": "tipo: 06","v": "128","k": "tipo"},943],
[{"f": "tipo: 06","v": "128","k": "tipo"},{"f": "magazzino: IC25","v": "127","k": "magazzino"},0],
[{"f": "#N/A","v": "146","k": "cesta"},{"f": "tipo: 0Y","v": "145","k": "tipo"},4393],
[{"f": "tipo: 0Y","v": "145","k": "tipo"},{"f": "magazzino: IC25","v": "127","k": "magazzino"},0],
[{"f": "magazzino: IC25","v": "127","k": "magazzino"},{"f": "ffile: PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","v": "126","k": "ffile"},0],
[{"f": "ffile: PRE-DIVISIONE UNDERCOLORS + SISLEY YOUNG.xlsx (98b3e01f-76c3-4326-bdbd-ebb079ccfb6d)","v": "126","k": "ffile"},"Importazioni",0]]
**/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment