JSFiddle - React, Tailwind, and code Playground
by csornmo
HTML
<table></table>
CSS
td {
border: 2px solid #ccc;
}
JavaScript
var baseData = [
{
"date" : "2020-02-23",
"week" : "8",
"vanlig" : 1,
"glutenfri": 2
},
{
"date" : "2020-02-24",
"week" : "9",
"vanlig" : 2,
"glutenfri": 4
},
{
"date" : "2020-02-24",
"week" : "9",
"vanlig" : 1,
"glutenfri": 2
},
{
"date" : "2020-02-24",
"week" : "9",
"vanlig" : 1,
"glutenfri": 2
}
];
var newData = [];
baseData.forEach(function(item, index) {
newData[item.date + item.week] = newData[item.date + item.week] ||
{ date: item.date, week: item.week, vanlig: 0, glutenfri: 0 };
newData[item.date + item.week].vanlig += item.vanlig;
newData[item.date + item.week].glutenfri += item.glutenfri;
});
console.log(Object.values(newData));
newData = Object.values(newData);
var sum;
$.each(newData, function(index, value) {
var date = value.date;
var week = value.week;
var vanlig = value.vanlig;
var glutenfri = value.glutenfri;
console.log(date);
sum += ('<tr><td>' + date + '</td><td>' + week + '</td><td>' + vanlig + '</td><td>' + glutenfri + '</td></tr>');
});
$('table').append(sum);