Skip welcome & menu and move to editor
Welcome to JS Bin
File
Add library
Share
Login or Register
Blog
Help
Load cached copy from
  • Run with JS
  • Save
  • Share
  • …
 
<!DOCTYPE html>
<html>
<head>
<script src="http://documentcloud.github.io/underscore/underscore-min.js"></script>
<meta charset=utf-8 />
<title>JS Bin</title>
</head>
<body>
  
</body>
</html>
 
var data_list = [{
  "insertDate": "2011-12-02T00:00",
  "value": {
    "paisa": 10000
  }
}, {
  "insertDate": "2013-03-02T00:00",
  "value": {
    "paisa": 10000
  }
}, {
  "insertDate": "2013-03-02T00:00",
  "value": {
    "paisa": 10000
  }
}, {
  "insertDate": "2012-12-02T00:00",
  "value": {
    "paisa": 30000
  }
}, {
  "insertDate": "2013-04-02T00:00",
  "value": {
    "paisa": 10000
  }
}, {
  "insertDate": "2013-04-02T00:00",
  "value": {
    "paisa": 30000
  }
}, {
  "insertDate": "2013-03-02T00:00",
  "value": {
    "paisa": 20000
  }
}, {
  "insertDate": "2013-04-12T00:00",
  "value": {
    "paisa": 30000
  }
}, {
  "insertDate": "2012-11-02T00:00",
  "value": {
    "paisa": 10000
  }
}];
​
var groupedByDateData = _.groupBy(data_list, function(date) {
  return date.insertDate.substring(0,7);
});
​
​
var aggregateByDate = _.map(groupedByDateData, function(invoiceObject, createdat) {
  return { 
     createdat: createdat, 
     val: _.reduce(invoiceObject, function(m,x) { 
       return m + x.value.paisa;
     }, 0) 
  };
});
​
​
​
console.log(aggregateByDate);
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers