高图表数据导入 JSON - 格式

Highcharts data import JSON - formatting

本文关键字:格式 JSON 导入 数据 高图表      更新时间:2023-09-26

我正在尝试获取一些数据以使用Highcharts渲染散点图。下面是一个数据示例。

{ "results": [ [ "2013-04-14 10:00", -1 ], 
               [ "2013-04-14 11:48", 0 ], 
               [ "2013-04-14 14:45", -1 ], 
               [ "2013-04-14 18:02", -1 ], 
               [ "2013-04-14 18:45", -1 ], 
               [ "2013-04-14 19:57", -1 ], 
               [ "2013-04-14 22:19", 0 ], 
               [ "2013-04-14 23:00", 0 ],
               [ "2013-04-14 23:00", -1 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-14 23:00", 0 ], 
               [ "2013-04-15 00:18", 0 ], 
               [ "2013-04-15 00:21", 0 ], 
               [ "2013-04-15 00:22", 0 ], 
               [ "2013-04-15 00:24", 1 ], 
               [ "2013-04-15 04:15", -1 ], 
               [ "2013-04-15 09:02", -1 ] 
             ] 
}

这是 js:

$(document).ready(function() {
  var options = {
    chart: {
        renderTo: 'container',
        type: 'scatter',
        zoomType: 'xy'
    },
    title: {
        text: 'Sentiment Report by Publish Date'
    },
    subtitle: {
        text: 'Written by Kat Chilton for Oxyme'
    },
    xAxis: {
        title: {
            text: 'Publish Date'
        },
        type: 'datetime'
    },
    yAxis: {
        min: 0,
        title: {
            text: 'Sentiment',
            align: 'high'
        },
        labels: {
            overflow: 'justify'
        }
    },
    plotOptions: {
        scatter: {
            marker: {
                radius: 5,
                states: {
                    hover: {
                        enabled: true,
                        lineColor: 'rgb(0,0,0)'
                    }
                }
            },
            states: {
                hover: {
                    marker: {
                        enabled: false
                    }
                }
            },
            allowPointSelect: true,
            dashStyle: 'dot',
        }
    },
    legend: {
        layout: 'vertical',
        align: 'left',
        verticalAlign: 'top',
        y: 0,
        floating: true,
        borderWidth: 1,
        backgroundColor: ((Highcharts.theme && Highcharts.theme.legendBackgroundColor) || '#FFFFFF'),
        shadow: true
    },
    credits: {
        enabled: false
    },
    series: [{}]
};
 $.getJSON('sample.json', function(data) {
    options.series[0].data = data;
    var chart = new Highcharts.Chart(options);
});

我没有在页面上呈现任何点,但图表确实与标题一起出现,而不是。我认为这是数据格式的问题,但我似乎找不到原因。谁能帮忙?

你需要从data那里获取results属性,就像这样

options.series[0].data = data.results;