在高级图表中使用JSON数据

Question

我有一些JSON数据：

data1=[
{"date": 1396828800, "impressions": 49145385},
{"date": 1396915200, "impressions": 46704447},
{"date": 1397001600, "impressions": 47181000},
{"date": 1397088000, "impressions": 47337965},
{"date": 1397174400, "impressions": 51129266},
{"date": 1397260800, "impressions": 60547397},
{"date": 1397347200, "impressions": 62217077},
{"date": 1397433600, "impressions": 49145385},
{"date": 1397520000, "impressions": 46704447},
{"date": 1397606400, "impressions": 47181000},
{"date": 1397692800, "impressions": 47337965},
{"date": 1397779200, "impressions": 51129266},
{"date": 1397865600, "impressions": 60547397}
];

我想把这个用图表显示出来。下面是我正在处理的模板：http://jsfiddle.net/hohenheim/j8cTE/9/

我怎样才能把这些数据放到图表中呢？

Answer 1

您需要对您的数据进行一些处理，才能将其转换为高级图表所需的格式。

for (var i=0;i< data1.length;i++) {
    data1[i] = [data1[i].date, data1[i].impressions];
}

http://jsfiddle.net/j8cTE/10/

然后将其用作系列：

    series: 
    [{
        data: data1   
    }]

Answer 2

替换

series: 
        [{
            data: [
                    [Date.UTC(2014, 0, 01), 1000],
                    [Date.UTC(2014, 0, 02), 1000],
                    [Date.UTC(2014, 0, 03), 1000],
                    [Date.UTC(2014, 0, 04), 1000]]    
        },
        { 
            data: [
                    [Date.UTC(2014, 0, 01), 1000],
                    [Date.UTC(2014, 0, 02), 1000],
                    [Date.UTC(2014, 0, 03), 1000],
                    [Date.UTC(2014, 0, 04), 1000]]
        }
        ] 

使用

series: [{data: data}]

此外，您还需要重新格式化您的数据，使其看起来像它们在那里显示的那样：

["date", 49145385]

而不是

{"date": 1396828800, "impressions": 49145385}