CustomGridLine and Date X Axis

[LunkwillAndFook]

 Is there a way to create a vertical customgridline with an X-axis that displays dates? I am trying to show the cumulative number of items completed over time (with forcasted date for the future) and I would like to have a vertical line to show the current date.

[JuanC]

You can use the Chart.dateToDouble method to translate a javascript date (note that it expects a date not a string) into a number, e.g.

   var data = [

                 { "Date": "2013-10-01T00:00:00.000Z", "Value": 15 },

                 { "Date": "2013-11-01T00:00:00.000Z", "Value": 9 },

                 { "Date": "2013-12-01T00:00:00.000Z", "Value": 12 },

                 { "Date": "2014-01-01T00:00:00.000Z", "Value": 14 },

                 { "Date": "2014-02-01T00:00:00.000Z", "Value": 18 },

                 { "Date": "2014-03-01T00:00:00.000Z", "Value": 9 },

                 { "Date": "2014-04-01T00:00:00.000Z", "Value": 12 },

                 { "Date": "2014-05-01T00:00:00.000Z", "Value": 15 },

                ];

    var axisX = chart1.getAxisX();

    axisX.getLabelsFormat().setFormat(cfx.AxisFormat.Date);

    axisX.getLabelsFormat().setCustomFormat("MMM yyyy");

    

    var dateToday = new Date(2014, 2, 12, 0, 0, 0, 0);

    var customGrid = new cfx.CustomGridLine();

    var value = cfx.Chart.dateToDouble(dateToday);

    customGrid.setValue(value);

    axisX.getCustomGridLines().add(customGrid);

    

    chart1.setDataSource(data);

 

JuanC