JavaScript
var Json=[
{"Date":"\/Date(1094927400000)\/","Category":"Mutual Fund","CategoryId":8,"HasChildren":0,"Amount":250}
,{"Date":"\/Date(1098210600000)\/","Category":"Travel","CategoryId":10,"HasChildren":1,"Amount":55}
,{"Date":"\/Date(1101061800000)\/","Category":"Food","CategoryId":7,"HasChildren":1,"Amount":20}
,{"Date":"\/Date(1101061800000)\/","Category":"Travel","CategoryId":10,"HasChildren":1,"Amount":8}
,{"Date":"\/Date(1104777000000)\/","Category":"Travel","CategoryId":10,"HasChildren":1,"Amount":40}
,{"Date":"\/Date(1107369000000)\/","Category":"Food","CategoryId":7,"HasChildren":1,"Amount":5}
,{"Date":"\/Date(1107369000000)\/","Category":"Travel","CategoryId":10,"HasChildren":1,"Amount":60}
,{"Date":"\/Date(1107628200000)\/","Category":"Energy","CategoryId":6,"HasChildren":0,"Amount":200}
,{"Date":"\/Date(1117737000000)\/","Category":"Other","CategoryId":9,"HasChildren":0,"Amount":10}
,{"Date":"\/Date(1118514600000)\/","Category":"Communication","CategoryId":5,"HasChildren":0,"Amount":34}
,{"Date":"\/Date(1118687400000)\/","Category":"Food","CategoryId":7,"HasChildren":1,"Amount":10}
,{"Date":"\/Date(1121106600000)\/","Category":"Communication","CategoryId":5,"HasChildren":0,"Amount":34}
];
function GetDateFromJSON(JDtStr)
{
var date = new Date(parseInt(JDtStr.replace(/(^.*\()|([+-].*$)/g, '')));
var day = date.getDate(); if(day < 10) day = '0' + day;
var month = date.getMonth() + 1; if(month<10) month = '0'+month;
var year = date.getFullYear();
//return (year+'-'+month+'-'+day);
return date;
}
$(function () {
console.clear();
var tempJson = {};
$.each(Json,function(){
var i=this.Category;
if(!tempJson[i]) tempJson[i]={label:i,data:[]};
tempJson[i].data.push([GetDateFromJSON(this.Date),this.Amount]);
});
var newJson = [];
$.each(tempJson,function(){newJson.push(this)});
console.log(newJson);
...