dynamic json array nested values for highcharts

by bilbobaggins

JavaScript

var red={"Ycount":"5","Xcount":"8","rows":[{"yaxis":"a","April":null,"August":null,"December":"1","February":null,"January":"1","March":"1","November":"1","September":"2"},{"yaxis":"F","April":"120102","August":"60050","December":"60008","February":"60051","January":"60008","March":"60008","November":"60008","September":"120016"},{"yaxis":"K","April":null,"August":null,"December":"1","February":null,"January":"1","March":"1","November":"1","September":"2"},{"yaxis":"m","April":"2","August":"1","December":null,"February":"1","January":null,"March":null,"November":null,"September":null},{"yaxis":"M","April":"179932","August":"89966","December":"90008","February":"89966","January":"90008","March":"90008","November":"90008","September":"180016"},{"yaxis":"total","April":"300036","August":"150017","December":"150018","February":"150018","January":"150018","March":"150018","November":"150018","September":"300036"}]}

var rawcontent=red.rows;
console.log(rawcontent)
var red = rawcontent.filter(function(doctor) {
           return doctor.yaxis !== 'total'; // if truthy then keep item
       }).map(function(nested) {
       console.log(nested)
           
            
           var red=Object.keys(nested).map(function(element) {
              var ar=[]
              ar.push(element)
              ar.push(nested[element])
               return ar ;
           });
           console.log(red[0][0]+"--"+red[0][1])
           
           return { name: red[0][1],
                id: red[0][1],
                data:red
                };
          
       });
       
      console.log(red)
/*

var redd=[{
                name: 'Microsoft Internet Explorer',
                id: 'Microsoft Internet Explorer',
                data: [
                    ['v11.0', 24.13],
                    ['v8.0', 17.2],
                    ['v9.0', 8.11],
                    ['v10.0', 5.33],
                    ['v6.0', 1.06],
                    ['v7.0', 0.5]
                ]
            },...