dongxue7306 2016-02-06 12:29
浏览 406
已采纳

格式化HighCharts中的日期

I have the following code:

  <script>
$.getJSON('https://www.quandl.com/api/v3/datasets/OPEC/ORB.json?order=asc', function(json) {
    var hiJson = json.dataset.data.map(function(d) {
      return [new Date(d[0]), d[1]]
    });

    // Create the chart
    $('#container').highcharts('chart', {
      rangeSelector: {
        selected: 1
      },
      title: {
        text: 'OPEC Crude Oil Price',
      },
      series: [{
        type: 'line',
        name: 'OPEC',
        data: hiJson,
      }]
    });
});

Which prints a beautiful chart as follows:

OPEC Crude Oil Price

But as you can see, the dates are not in the correct format. I am struggling to work out what is wrong?

All help much appreciated as always!

UPDATE:

So thanks to Holvar's comment I solved one problem, but now I have another on the same theme.

My code is as follows:

<script>
$.getJSON('https://www.quandl.com/api/v3/datasets/BOE/IUAAAMIH.json?auth_token=pg6FBmvfQazVFdUgpqHz&start_date=2003-01-02&order=asc', function(json) {
    var hiJson = json.dataset.data.map(function(d) {
      return [new Date(d[0]), d[1]]
    });

    // Create the chart
    $('#interest').highcharts('chart', {
      xAxis: {
        type: 'datetime',
        dateTimeLabelFormats: {
                          day: '%Y'
                      }  
      },            
      rangeSelector: {
      selected: 1
      },
      title: {
        text: 'UK Interest Rates',
      },
      series: [{
        type: 'line',
        name: 'Interest Rate',
        data: hiJson,
      }]
    });
});

But this produces a chart without dates on the bottom. I'd like years from 2003-01-02. The chart looks like this

UK Interest Rate

I don't understand why it's not showing an annual date as in the solution to the initially posed question?!

You help is much appreciated!

  • 写回答

1条回答 默认 最新

  • dsbc80836 2016-02-06 15:09
    关注

    I believe the issue is with the way the data map is happening. The ending array contains multiple arrays, instead of an object with "x" and "y" properties. Try changing the initialization of the hiJson variable to something like:

    var hiJson = json.dataset.data.map(function(d) { return { x: new Date(d[0]), y: d[1] }; });

    That seems to be working on my local environment.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 华为nova10pro ,关闭热动热点用量记录
  • ¥15 JavaFX启动SceneBuilder报错,找不到fxml文件
  • ¥15 树莓派ubuntu使用conda就提示core dumped
  • ¥15 帮我看看这是个啥题,带解题过程和结果,条件如下FCF = 290471.33 g1 = 15% r = 8% g2 = 4% n = 5
  • ¥15 edem模拟颗粒不显示或者生成失败
  • ¥15 Python代码编写
  • ¥15 php 将rtmp协议转hls协议,无法播放
  • ¥20 python代码编写
  • ¥20 使用MPI广播数据遇到阻塞
  • ¥15 TinyMCE如何去掉自动弹出的“链接…”工具?