CODEWITHSUNDEEP
javascriptjsongoogle-visualization
Dheeraj Palagiri
Dheeraj Palagiri

Reputation: 1879

Google Chart From Json "undefined is not a function"

I am trying to work with google charts for the first time. My Json is as below

{\"cols\":[{\"id\":\"Date\",\"label\":\"Date\",\"type\":\"date\"},{\"id\":\"KeywordCount\",\"label\":\"count\",\"type\":\"number\"}],\"rows\":[{\"c\":
[{\"v\":\"new Date(2014725)\",\"f\":\"25 July 2014\"},{\"v\":\"77\",\"f\":\"77\"}]},{\"c\":
[{\"v\":\"new Date(2014724)\",\"f\":\"24 July 2014\"},{\"v\":\"101\",\"f\":\"101\"}]},{\"c\":
[{\"v\":\"new Date(2014723)\",\"f\":\"23 July 2014\"},{\"v\":\"100\",\"f\":\"100\"}]},{\"c\":
[{\"v\":\"new Date(2014722)\",\"f\":\"22 July 2014\"},
{\"v\":\"130\",\"f\":\"130\"}]}],\"p\":null}

This looks good for me, I am not able to figured it out what i am missing because i can only see an error in the chart ("undefined is not a function") . My javascript file for Google charts are

google.load('visualization', '1', { 'packages': ['corechart'] });
var postDate = $('#ReportingWall').serialize();

function drawChartAll() {
    var jsonData = $.ajax({
        url: '/ReportingWall/analyseStats/',
        type: 'POST',
        data: postDate,
        dataType: 'json',
        async: false,
        success: function (response) {
        }
    }).responseText;

    var data = new google.visualization.DataTable(jsonData);

    console.debug(jsonData);
    console.debug(data);
    var chart = new google.visualization.LineChart(document.getElementById('charts_all'));
    chart.draw(data, options);

    var columns = [];
    var series = {};
    for (var i = 0; i < data.getNumberOfColumns() ; i++) {
        columns.push(i);
        if (i > 0) {
            series[i - 1] = {};
        }
    }

    var options = {
        title: 'Keywords:',
        width: 908,
        legend: {
            position: 'right'
        },
        legendFontSize: 14,
        chartArea: {
            left: 50,
            width: '80%'
        },
        series: series
    }

    google.visualization.events.addListener(chart, 'select', function () {
        var sel = chart.getSelection();
        // if selection length is 0, we deselected an element
        if (sel.length > 0) {
            // if row is undefined, we clicked on the legend
            if (sel[0].row === null) {
                var col = sel[0].column;
                if (columns[col] == col) {
                    // hide the data series
                    columns[col] = {
                        label: data.getColumnLabel(col),
                        type: data.getColumnType(col),
                        calc: function () {
                            return null;
                        }
                    };

                    // grey out the legend entry
                    series[col - 1].color = '#CCCCCC';
                } else {
                    // show the data series
                    columns[col] = col;
                    series[col - 1].color = null;
                }
                var view = new google.visualization.DataView(data);
                view.setColumns(columns);
                chart.draw(view, options);
            }
        }
    });
}

Upvotes: 2

Views: 1958

Answers (2)

asgallant
asgallant

Reputation: 26340

When using dates in the DataTable JSON structure, you must omit the new keyword; you are constructing a string that the Visualization API will parse into a Date object, not constructing a Date object itself.

{
    "cols":[
        {"id":"Date","label":"Date","type":"date"},
        {"id":"KeywordCount","label":"count","type":"number"}
    ],
    "rows":[
        {"c":[{"v":"Date(2014725)","f":"25 July 2014"},{"v":77,"f":"77"}]},
        {"c":[{"v":"Date(2014724)","f":"24 July 2014"},{"v":101,"f":"101"}]},
        {"c":[{"v":"Date(2014723)","f":"23 July 2014"},{"v":100,"f":"100"}]},
        {"c":[{"v":"Date(2014722)","f":"22 July 2014"},{"v":130,"f":"130"}]}
    ],
    "p":null
}

Upvotes: 2

Oren Efron
Oren Efron

Reputation: 409

If you clean it up a bit you can see in the last row you have a useless " as last char

{"cols":[
    {"id":"Date","label":"Date","type":"date"},
    {"id":"KeywordCount","label":"count","type":"number"}],
"rows":[
    {"c":[{"v":"new Date(2014725)","f":"25 July 2014"},{"v":"77","f":"77"}]},
    {"c":[{"v":"new Date(2014724)","f":"24 July 2014"},{"v":"101","f":"101"}]},
    {"c":[{"v":"new Date(2014723)","f":"23 July 2014"},{"v":"100","f":"100"}]},
    {"c":[{"v":"new Date(2014722)","f":"22 July 2014"},{"v":"130","f":"130"}]}],
"p":null}"

also start with a sample similar of PHP

OR this ajax http://www.santarosa.edu/~jperetz/projects/ajax-json/

Upvotes: 1

Related Questions