javascript - 为什么 HighCharts 无法正确识别我的数据？-6ren

javascript - 为什么 HighCharts 无法正确识别我的数据？

转载作者：行者123 更新时间：2023-12-03 03:50:20

目标:
在散点图上绘制 JSON 数据。每个对象包含 3 个值，但应忽略最后一个值(ID 数组)——无需在图表上表示它。

问题:
HighCharts 似乎无法识别我的 x 数据。它不会根据我的数据缩放 x 轴(日期时间)。它确实理解我的 y 值。它显示在图表中。

你在做什么？
我正在获取一个 JSON 字符串，在其上使用 JSON.parse()，将日期设置为 YYYY-MM-DD 而不是 UTC，然后我将 myArray['vector'] 提供给 HighChart 数据键。

想法:
我相信这与我构建 JSON 字符串的方式或将其传递给键/值对 data 的方式有关。我对如何将 JSON 数据“转换”为键/值对感到有点困惑。

下面是结果。请注意 x 轴没有刻度。这些值也按其在数组中的位置排列(而不是按日期排列)

JSON:

{
   "vector":[
              [
                 "2017-06-06T04:31:16.000Z",
                 0.42,
                 [
                    "10155104233200659_10155105320445659",
                    "10155107157865659_10155107413550659",
                    "10155100854365659_10155101259520659",
                    "10155098835305659_10155101265245659",
                    "10155100854365659_10155101191290659",
                    "10155100854365659_10155101285415659",
                    "10155100854365659_10155101300165659",
                    "10155100854365659_10155101337070659",
                    "10155100854365659_10155101354640659",
                    "1558728630806541_1561351187210952",
                    "10155101928310659_10155102129290659",
                    "10155100854365659",
                    "10155101928310659_10155102183210659",
                    "10155101455910659_10155101458430659",
                    "1561546217191449_1561590010520403",
                    "10155101455910659_10155101459025659",
                    "10155101455910659_10155101461415659",
                    "10155101455910659_10155102138275659",
                    "10155101928310659_10155102150395659",
                    "10155101455910659_10155101462715659",
                    "870299173970694144",
                    "10155101455910659_10155101466670659",
                    "10155100854365659_10155101699660659",
                    "10155100854365659_10155102227220659",
                    "10155100854365659_10155102338105659",
                    "10155101928310659_10155102363275659",
                    "10155101455910659_10155101723225659",
                    "1561432737202797",
                    "10155101928310659_10155102372445659",
                    "10155101455910659_10155101481925659"
                 ]
              ],
              [
                 "2017-06-01T03:06:45.000Z",
                 0.47,
                 [
                    "10155078962635659_10155088932395659",
                    "10155086108505659_10155086203305659",
                    "10155086108505659_10155086234940659",
                    "10155085853500659_10155089736675659",
                    "10155086108505659_10155086284290659",
                    "10155086108505659_10155086294655659",
                    "868637256197840896",
                    "10155086108505659_10155086299195659",
                    "10155089549730659_10155089737300659",
                    "10155086108505659_10155086390050659",
                    "10155086108505659_10155086391925659",
                    "10155080256225659_10155089749815659",
                    "10155089549730659_10155090102235659",
                    "10155089549730659_10155090105425659",
                    "10155089549730659_10155090154310659",
                    "10155089549730659_10155090160515659",
                    "10155089549730659_10155090191730659",
                    "10155089549730659_10155090365070659",
                    "10155041106080659_10155086572640659",
                    "10155086108505659_10155086121160659",
                    "10155086108505659_10155086155370659",
                    "10155085853500659_10155086166860659",
                    "10155086108505659_10155086173400659",
                    "10155086108505659_10155086176665659",
                    "10155086108505659_10155086186500659",
                    "10155086108505659_10155086189325659",
                    "10155086108505659_10155086193075659",
                    "10155086108505659_10155086197225659",
                    "10155086108505659_10155086635920659",
                    "10155086108505659_10155087687155659"
                 ]
              ],
              [
                 "2017-05-26T03:32:24.000Z",
                 0.43,
                 [
                    "10155076988775659_10155077020050659",
                    "10155076988775659_10155077018590659",
                    "10155076988775659_10155077016610659",
                    "10155076988775659_10155077018385659",
                    "10155076988775659_10155077016860659",
                    "10155076988775659_10155077016865659",
                    "10155076988775659_10155077018410659",
                    "10155076988775659_10155077016530659",
                    "10155076988775659_10155077015135659",
                    "10155076988775659_10155077017130659",
                    "10155076988775659_10155077016630659",
                    "10155076988775659_10155077015210659",
                    "10155076988775659_10155077015205659",
                    "10155076988775659_10155077018990659",
                    "10155076988775659_10155077015255659",
                    "10155076988775659_10155077017270659",
                    "10155076988775659_10155077013155659",
                    "10155076988775659_10155077016690659",
                    "10155076988775659_10155077019325659",
                    "10155076988775659_10155077017305659",
                    "10155076988775659_10155077017385659",
                    "10155076677150659_10155077073125659",
                    "10155076677150659_10155077036660659",
                    "10155076988775659_10155077017615659",
                    "10155076988775659_10155077019365659",
                    "10155076988775659_10155077017695659",
                    "10155076988775659_10155077017680659",
                    "10155076988775659_10155077017780659",
                    "10155076988775659_10155077017760659",
                    "10155076568000659_10155077074260659"
                 ]
              ],
              [
                 "2017-05-07T03:02:04.000Z",
                 0.8,
                 [
                    "15a1e146e7ed603aecbe16de25ed53fc",
                    "10155015378740659_10155015486550659",
                    "10155011834555659_10155013722600659",
                    "10155015378740659_10155015483050659",
                    "10155012171695659_10155022393165659",
                    "859973050628026368",
                    "860299410340630528",
                    "860096826610941952",
                    "859989850455408642",
                    "7d79e45313c878ec78a0b34de60c69f3",
                    "860127021120327680",
                    "860300107266138112",
                    "860311173073391617",
                    "860312531407163393",
                    "860316615765876736",
                    "860156681401114626",
                    "860317260409257985",
                    "Qd_q0XF0Y10",
                    "860166160851099649",
                    "860190399180222466",
                    "860204548777889792",
                    "860211634886901760",
                    "1529799180366153_1532172110128860",
                    "860269305077870592",
                    "860287769960165376",
                    "860297098775982082",
                    "860162336727977985",
                    "10155014502490659_10155016027360659",
                    "1532221810123890_1533617433317661",
                    "10155015378740659_10155015420560659"
                 ]
              ],
              [
                 "2017-05-04T03:08:33.000Z",
                 0.55,
                 [
                    "10155005822955659_10155006234215659",
                    "10155005822955659_10155006238455659",
                    "10155005609550659_10155006194705659",
                    "10155005822955659_10155006241065659",
                    "10155005822955659_10155006241655659",
                    "10155005822955659_10155006177605659",
                    "10155005114840659_10155006201270659",
                    "10155005609550659_10155006091430659",
                    "10155005609550659_10155006095520659",
                    "10155005609550659_10155006099105659",
                    "10155002652900659_10155006101040659",
                    "10155005822955659_10155006101600659",
                    "10155005609550659_10155006109155659",
                    "10155002652900659_10155006110655659",
                    "10155005822955659_10155006113965659",
                    "10155005609550659_10155006132275659",
                    "10155005609550659_10155006139910659",
                    "10155005822955659_10155006142495659",
                    "10155005609550659_10155006143850659",
                    "10154997175925659_10155006178085659",
                    "10155005822955659_10155006148580659",
                    "10155005609550659_10155006190080659",
                    "10155005114840659_10155006154345659",
                    "10155005822955659_10155006154825659",
                    "10155005114840659_10155006167935659",
                    "10155005609550659_10155006157700659",
                    "10155005114840659_10155006160225659",
                    "10155005609550659_10155006231175659",
                    "10155005609550659_10155006187295659",
                    "10155005822955659_10155006162850659"
                 ]
              ],
              [
                 "2017-05-02T03:01:57.000Z",
                 0.49,
                 [
                    "874302750531694592",
                    "851862555752640513",
                    "851862767925637120",
                    "874318907250757634",
                    "874329266107936768",
                    "874335249144086531",
                    "851870647521341443",
                    "874107458871894021",
                    "851772861501059072",
                    "874355138969956352",
                    "874250856476139520",
                    "874274312253034496",
                    "874278730088280066",
                    "874356894428798977",
                    "851893814474264576",
                    "874666827904937985",
                    "851923766158520320",
                    "851891395493101568",
                    "874684725188845572",
                    "874685434911236098",
                    "874391730396708864",
                    "874396116737019909",
                    "874737533766311937",
                    "874799536073519104",
                    "874817322791313409",
                    "851892924115582977",
                    "874396860777091072",
                    "874551209625100288",
                    "874558005903335424",
                    "874609184905588736"
                 ]
              ],
              [
                 "2017-04-11T03:04:21.000Z",
                 0.54,
                 [
                    "872880479300603905",
                    "872905370355855361",
                    "872914304227475460",
                    "872661418985877506",
                    "872662404416638976",
                    "872922590024794115",
                    "872923180117241856",
                    "872967240488034305",
                    "872980087943176193",
                    "872989868145741829",
                    "872997173008486402",
                    "872880235649392640",
                    "873003042869792790",
                    "872941776868433921",
                    "873004432853696512",
                    "872841099542450178",
                    "872767600647954435",
                    "872819121804726272",
                    "872940586894061568",
                    "872985706150350848",
                    "872762907746066432",
                    "872869944161165312",
                    "872880243824103424",
                    "872846343147999233",
                    "873015156883812353",
                    "872938894320390145",
                    "872655599145824256",
                    "873351602639384576",
                    "873352989515403264",
                    "ea4b7c58ceee69909aad70a8d25f46ef"
                 ]
              ]
   ]
}

JavaScript 和 HighCharts 初始化:

var myJSON = '{"vector":[["2017-06-06T04:31:16.000Z",0.42,["10155104233200659_10155105320445659","10155107157865659_10155107413550659","10155100854365659_10155101259520659","10155098835305659_10155101265245659","10155100854365659_10155101191290659","10155100854365659_10155101285415659","10155100854365659_10155101300165659","10155100854365659_10155101337070659","10155100854365659_10155101354640659","1558728630806541_1561351187210952","10155101928310659_10155102129290659","10155100854365659","10155101928310659_10155102183210659","10155101455910659_10155101458430659","1561546217191449_1561590010520403","10155101455910659_10155101459025659","10155101455910659_10155101461415659","10155101455910659_10155102138275659","10155101928310659_10155102150395659","10155101455910659_10155101462715659","870299173970694144","10155101455910659_10155101466670659","10155100854365659_10155101699660659","10155100854365659_10155102227220659","10155100854365659_10155102338105659","10155101928310659_10155102363275659","10155101455910659_10155101723225659","1561432737202797","10155101928310659_10155102372445659","10155101455910659_10155101481925659"]],["2017-06-01T03:06:45.000Z",0.47,["10155078962635659_10155088932395659","10155086108505659_10155086203305659","10155086108505659_10155086234940659","10155085853500659_10155089736675659","10155086108505659_10155086284290659","10155086108505659_10155086294655659","868637256197840896","10155086108505659_10155086299195659","10155089549730659_10155089737300659","10155086108505659_10155086390050659","10155086108505659_10155086391925659","10155080256225659_10155089749815659","10155089549730659_10155090102235659","10155089549730659_10155090105425659","10155089549730659_10155090154310659","10155089549730659_10155090160515659","10155089549730659_10155090191730659","10155089549730659_10155090365070659","10155041106080659_10155086572640659","10155086108505659_10155086121160659","10155086108505659_10155086155370659","10155085853500659_10155086166860659","10155086108505659_10155086173400659","10155086108505659_10155086176665659","10155086108505659_10155086186500659","10155086108505659_10155086189325659","10155086108505659_10155086193075659","10155086108505659_10155086197225659","10155086108505659_10155086635920659","10155086108505659_10155087687155659"]],["2017-05-26T03:32:24.000Z",0.43,["10155076988775659_10155077020050659","10155076988775659_10155077018590659","10155076988775659_10155077016610659","10155076988775659_10155077018385659","10155076988775659_10155077016860659","10155076988775659_10155077016865659","10155076988775659_10155077018410659","10155076988775659_10155077016530659","10155076988775659_10155077015135659","10155076988775659_10155077017130659","10155076988775659_10155077016630659","10155076988775659_10155077015210659","10155076988775659_10155077015205659","10155076988775659_10155077018990659","10155076988775659_10155077015255659","10155076988775659_10155077017270659","10155076988775659_10155077013155659","10155076988775659_10155077016690659","10155076988775659_10155077019325659","10155076988775659_10155077017305659","10155076988775659_10155077017385659","10155076677150659_10155077073125659","10155076677150659_10155077036660659","10155076988775659_10155077017615659","10155076988775659_10155077019365659","10155076988775659_10155077017695659","10155076988775659_10155077017680659","10155076988775659_10155077017780659","10155076988775659_10155077017760659","10155076568000659_10155077074260659"]],["2017-05-07T03:02:04.000Z",0.8,["15a1e146e7ed603aecbe16de25ed53fc","10155015378740659_10155015486550659","10155011834555659_10155013722600659","10155015378740659_10155015483050659","10155012171695659_10155022393165659","859973050628026368","860299410340630528","860096826610941952","859989850455408642","7d79e45313c878ec78a0b34de60c69f3","860127021120327680","860300107266138112","860311173073391617","860312531407163393","860316615765876736","860156681401114626","860317260409257985","Qd_q0XF0Y10","860166160851099649","860190399180222466","860204548777889792","860211634886901760","1529799180366153_1532172110128860","860269305077870592","860287769960165376","860297098775982082","860162336727977985","10155014502490659_10155016027360659","1532221810123890_1533617433317661","10155015378740659_10155015420560659"]],["2017-05-04T03:08:33.000Z",0.55,["10155005822955659_10155006234215659","10155005822955659_10155006238455659","10155005609550659_10155006194705659","10155005822955659_10155006241065659","10155005822955659_10155006241655659","10155005822955659_10155006177605659","10155005114840659_10155006201270659","10155005609550659_10155006091430659","10155005609550659_10155006095520659","10155005609550659_10155006099105659","10155002652900659_10155006101040659","10155005822955659_10155006101600659","10155005609550659_10155006109155659","10155002652900659_10155006110655659","10155005822955659_10155006113965659","10155005609550659_10155006132275659","10155005609550659_10155006139910659","10155005822955659_10155006142495659","10155005609550659_10155006143850659","10154997175925659_10155006178085659","10155005822955659_10155006148580659","10155005609550659_10155006190080659","10155005114840659_10155006154345659","10155005822955659_10155006154825659","10155005114840659_10155006167935659","10155005609550659_10155006157700659","10155005114840659_10155006160225659","10155005609550659_10155006231175659","10155005609550659_10155006187295659","10155005822955659_10155006162850659"]],["2017-05-02T03:01:57.000Z",0.49,["874302750531694592","851862555752640513","851862767925637120","874318907250757634","874329266107936768","874335249144086531","851870647521341443","874107458871894021","851772861501059072","874355138969956352","874250856476139520","874274312253034496","874278730088280066","874356894428798977","851893814474264576","874666827904937985","851923766158520320","851891395493101568","874684725188845572","874685434911236098","874391730396708864","874396116737019909","874737533766311937","874799536073519104","874817322791313409","851892924115582977","874396860777091072","874551209625100288","874558005903335424","874609184905588736"]],["2017-04-11T03:04:21.000Z",0.54,["872880479300603905","872905370355855361","872914304227475460","872661418985877506","872662404416638976","872922590024794115","872923180117241856","872967240488034305","872980087943176193","872989868145741829","872997173008486402","872880235649392640","873003042869792790","872941776868433921","873004432853696512","872841099542450178","872767600647954435","872819121804726272","872940586894061568","872985706150350848","872762907746066432","872869944161165312","872880243824103424","872846343147999233","873015156883812353","872938894320390145","872655599145824256","873351602639384576","873352989515403264","ea4b7c58ceee69909aad70a8d25f46ef"]]]}';;


    var myArray = JSON.parse(myJSON);

    $.each(myArray['vector'],function(index, value){
        //Reduce the datetime to just YYYY-MM-DD
        myArray['vector'][index][0] = myArray['vector'][index][0].substring(0,10);
    });

$(document).ready(function(){


    Highcharts.setOptions({
        global: {
            useUTC: false
        }
    });

    Highcharts.chart('container', {

        chart:{
            zoomType:'x',
        },
        exporting: {
            enabled: false 
        },
        xAxis: {
            type: 'datetime',
            title:{text:'Time'},
            tickInterval: 1000 * 60 * 60 * 24
        },
        yAxis: {
            max:1,
            min: 0,
            title:{ text: 'Focus of Conversations'},              
            plotBands: [{
                        color: 'black',
                        from: .5, // Start of the plot band
                        to: .51 // End of the plot band
                      }]
        },

        title: {
            text: 'Focus of Conversations Over Time'
        },

        series: [
        {
            type: 'scatter',
            data: myArray['vector'],
            marker: {  radius: 8 },
            showInLegend: false
        }]
    });
});

最佳答案

问题已解决。我将 YYYY-MM-DD 日期转换为自纪元以来的秒数，一切正常。

我改变了这个...

 $.each(myArray['vector'],function(index, value){
    //Reduce the datetime to just YYYY-MM-DD
    myArray['vector'][index][0] = myArray['vector'][index][0].substring(0,10);
});

对此...

$.each(myArray['vector'],function(index, value){
    //Reduce the datetime to just YYYY-MM-DD
    console.log(myArray['vector'][index][0].substring(0,10));
    myArray['vector'][index][0] = (new Date(myArray['vector'][index][0].substring(0,10))).getTime();
});

关于javascript - 为什么 HighCharts 无法正确识别我的数据？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/45197234/

文章推荐： javascript - Onkeydown javascript 数学

文章推荐： javascript - 使用 JQuery 在 DIV 中包含 php 页面

android -/数据/数据/在哪里？
初学者 android 问题。好的，我已经成功写入文件。例如。 //获取文件名 String filename = getResources().getString(R.string.filename
安卓/数据/数据/mypackage/img
我已经将相同的图像保存到/data/data/mypackage/img/中，现在我想显示这个全屏，我曾尝试使用 ACTION_VIEW 来显示 android 标准程序，但它不是从/data/dat
ios - Swift 4:无法将“数据”类型的值转换为预期的参数类型“数据”
我正在使用Xcode 9，Swift 4。我正在尝试使用以下代码从URL在ImageView中显示图像: func getImageFromUrl(sourceUrl: String) -> UII
android - 基因运动。如何从设备中提取数据库。我的/数据/数据/文件夹似乎是空的
我的 Ubuntu 安装 genymotion 有问题。主要是我无法调试我的数据库，因为通过 eclipse 中的 DBMS 和 shell 中的 adb 我无法查看/data/文件夹的内容。没有显示
php - JSON 数据 ajax 不是正确的 POST 数据
我正在尝试用 PHP 发布一些 JSON 数据。但是出了点问题。这是我的 html -- {% for x in sets %}
r - lm(数据~时间)和tslm(数据~趋势)有什么区别
我观察到两种方法的结果不同。为什么是这样？我知道 lm 上发生了什么，但无法弄清楚 tslm 上发生了什么。 > library(forecast) > set.seed(2) > tts lm(t
Spring 数据 JPA 和 Spring 数据 Elasticsearch ；找不到类型的属性索引？
我不确定为什么会这样!我有一个由 spring data elasticsearch 和 spring data jpa 使用的类，但是当我尝试运行我的应用程序时出现错误。 Error creatin
d3.js - 数据过滤器适用于 json 数据，但不适用于 csv 数据
在 this vega 图表，如果我下载并转换 flare-dependencies.json使用以下 jq 到 csv命令， jq -r '(map(keys) | add | unique) as
php - 在 .php 文件中发送 mysql 数据/mysql 数据
我正在提交一个项目，我必须在其中创建一个带有表的 mysql 数据库。一切都在我这边进行，所以我只想检查如何将我所有的压缩文件发送给使用不同计算机的人。基本上，我如何为另一台计算机创建我的数据库文件，
android - 如何使用 Android Device Monitor 的文件资源管理器查找我的应用程序/数据/数据
我有一个应用程序可以将文本文件写入内部存储。我想仔细看看我的电脑。我运行了 Toast.makeText 来显示路径，它说:/数据/数据/我的包但是当我转到 Android Studio 的 An
android - 如何从 Genymotion 的 android 模拟器访问文件/数据/数据？
我喜欢使用 Genymotion 模拟器以如此出色的速度加载 Android。它有非常好的速度，但仍然有一些不稳定的性能。如何从 Eclipse 中的文件资源管理器访问 Genymotion 模拟器
silverlight - 如果我在 setter 中使用不同的值更改绑定(bind)数据，如何刷新绑定(bind)数据
我需要更改 Silverlight 中文本框的格式。数据通过 MVVM 绑定(bind)。例如，有一个 int 属性，我将 1 添加到 setter 中的值并调用 OnPropertyChanged
youtube - 通过 YouTube 数据 API 访问公共(public)数据，无需身份验证。
我想向 Youtube Data API 提出请求，但我不需要访问任何用户信息。我只想浏览公共(public)视频并根据搜索词显示视频。我可以在未经授权的情况下这样做吗？最佳答案 YouTube
python - 无法让 twilio 显示 'from' 数据，但它会显示 'to' 数据
我已经设置了一个 Twilio 应用程序，我想向人们发送更新，但我不想回复单个文本。我只是想让他们在有问题时打电话。我一切正常，但我想在发送文本时显示传入文本，以确保我不会错过任何问题。我正在使用 p
javascript - 向客户端发送 JSON 数据？ D3.js 渲染 JSON 数据
我有一个带有表单的网站(目前它是纯 HTML，但我们正在切换到 JQuery)。流程是这样的: 接受用户的输入 --- 5 个整数通过 REST 调用网络服务在服务器端运行一些计算...并生成一个
javascript - 如何检测一个 JavaScript 文件只包含 JSON 数据，还是打算包含 JSON 数据？
假设我们有一个名为 configuration.js 的文件，当我们查看内部时，我们会看到: 'use strict'; var profile = { "project": "%Projec
javascript - 在初始 .ajax 调用之外使用 JSON 数据 - 访问剩余的 JSON 数据
这部分是对 Previous Question 的扩展我的: 我现在可以从我的 CI Controller 成功返回 JSON 数据，它返回: {"results":[{"id":"1","Sourc
ios - 删除所有 Couchbase 数据/文档 ios(或删除所有 ios 数据？)
有什么有效的方法可以删除 ios 中 CBL 的所有文档存储？我对此有疑问，或者，如果有人知道如何从本质上使该应用程序像刚刚安装一样，那也会非常有帮助。我们正在努力确保我们的注销实际上将应用程序设置为
javascript - $.post(url, 函数(数据,状态) {警报(数据)});警报()不工作
我有一个 Rails 应用程序，它与其他 Rails 应用程序通信以进行数据插入。我使用 jQuery $.post 方法进行数据插入。对于插入，我的其他 Rails 应用程序显示 200 OK。但在
javascript - 断言错误 : expected { status: 'SUCCESS' , 数据 : [] } to equal { Object (status, 数据)}
我正在为服务于发布请求的 API 调用运行单元测试。我正在传递请求正文，并且必须将响应作为帐户数据返回。但我只收到断言错误注意:数据是从 Azure 中获取的 spec.js const accou

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

javascript - 为什么 HighCharts 无法正确识别我的数据？