Out putting A JSON Value from a AJAX function.

Question

0.00/5 (No votes)

See more:

Hi all,

I have a question regarding an AJAX Function. It is at the below.

JavaScript

function setJsonSer(){

				formData = {
        			'Email': 'clientlink@russell.com',
        			'Password': 'russell1234',
        			'URL': getVaria()
    			};

    				$.ajax({
        			url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
        			type: 'POST',
        			data: formData,
        			complete: function(data) {
            			alert("This is Set JSON In  "+JSON.stringify(data));
	    			}

    			});
    
				$.ajax({
        			url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
        			type: 'GET',
        			data: formData,
        			complete: function(data) {
            			alert("This is Get JSON Out  "+JSON.stringify(data));
        			}
    			});

}

Above function setJsonSer() generate a JSON string according to aQueryString from Google Analytics. The JSON String creation is ok and it will display using an alert statement like in the below

JavaScript

alert("This is Set JSON In  "+JSON.stringify(data));

If it's displaying correctly means that it is giving me the correct JSON value. So now I want to not to alert that value but to pass to a variable that resides outside of that SetJsonSer() function.

Look at the following code snippet. In there rowData variable is used to set the JSON response. But that response is static. What I wanted to do is get 2 dates from a HTML form and pass them to to an Analytics Query and according to that query build the JSON response and pass that response to rowData variable.

Update

Below resides the complete JavaScript code block.

JavaScript

function retStartDate(){

var strStartDate = document.getElementById("from_date").value;
//alert("Start date " + strStartDate);
return strStartDate;

}

function retEndDate(){

var strEndDate = document.getElementById("to_date").value;
//alert("End date " + strEndDate);
return strEndDate;

}

function getVaria(){

var strWsUrl = 'https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Asource&metrics=ga%3Ausers&filters=ga%3Asource!%3D(direct)&sort=-ga%3Ausers&start-date= ' + retStartDate() + ' &end-date= ' + retEndDate() + ' &max-results=10';
//alert("Chart 1 query is "+ strWsUrl);
return strWsUrl;

}

function setJsonSer() {
    				formData = {
        			'Email': 'clientlink@russell.com',
        			'Password': 'russell1234',
        			'URL': getVaria()
    			};
    				$.ajax({
        			url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
        			type: 'POST',
        			data: formData,
        			complete: function(data) {
            			alert("This is Set JSON In  "+JSON.stringify(data));
        			}
    			});
    
				$.ajax({
        			url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
        			type: 'GET',
        			data: formData,
        			complete: function(data) {
            			alert("This is Get JSON Out  "+JSON.stringify(data));
        			}
    			});
			
		}

function BarChart(inData) {
	var labels = new Array();
	var values = new Array();
	
	for (var key in inData.rows) {
		var dt = new Array();
		dt[0] = parseInt(inData.rows[key][1]);
		var jsRow = { name: inData.rows[key][0], data: dt };
	   
		labels[key] = jsRow;
	}
	
	$(function () {
		$('#container').highcharts({
			chart: {
				type: 'column'
			},
			title: {
				text: 'Which Source brought more users?'
			},
			subtitle: {
				text: 'Source: Google Analytics'
			},
			xAxis: {
				categories: ['Source'],
				title: {
					text: null
				}
			},
			yAxis: {
				min: 0,
				title: {
					text: 'Number of Users',
					align: 'high'
				},
				labels: {
					overflow: 'justify'
				}
			},
			tooltip: {
				valueSuffix: null
			},
			plotOptions: {
				bar: {
					dataLabels: {
						enabled: true
					}
				}
			},
			legend: {
				layout: 'vertical',
				align: 'right',
				verticalAlign: 'top',
				x: -40,
				y: 100,
				floating: true,
				borderWidth: 1,
				backgroundColor: '#FFFFFF',
				shadow: true
			},
			credits: {
				enabled: false
			},
			series: labels
		});
	});

}

google.load('visualization', '1', { packages: ['table'] });

google.load("visualization", "1", { packages: ["corechart"] });


function Load(){

var labels = new Array();
            var values = new Array();
            var catogories = new Array();
            var arrayOfArray = new Array();
            //alert('func');
            var rowData =

'{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:date&metrics=ga:uniquePageviews,ga:bounces&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:date","metrics":["Unique Page views","Bounces"],"start-index":1,"max-results":1000},"itemsPerPage":1000,"totalResults":115,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:date&metrics=ga:uniquePageviews,ga:bounces&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:date","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:uniquePageviews","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:bounces","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:uniquePageviews":"2663","ga:bounces":"1048"},"rows":[["20140101","75","60"],["20140102","173","108"],["20140103","98","76"],["20140104","1","1"],["20140105","4","2"],["20140106","14","8"],["20140107","11","7"],["20140108","23","10"],["20140109","21","5"],["20140110","45","4"],["20140111","24","0"],["20140112","5","2"],["20140113","33","4"],["20140114","41","7"],["20140115","25","9"],["20140116","16","7"],["20140117","19","8"],["20140118","9","5"],["20140119","7","2"],["20140120","5","5"],["20140121","25","6"],["20140122","15","11"],["20140123","42","3"],["20140124","2","2"],["20140125","2","1"],["20140126","4","1"],["20140127","23","6"],["20140128","16","3"],["20140129","39","8"],["20140130","9","6"],["20140131","18","7"],["20140201","6","6"],["20140202","5","3"],["20140203","31","15"],["20140204","21","7"],["20140205","43","6"],["20140206","19","6"],["20140207","25","7"],["20140208","4","2"],["20140209","5","2"],["20140210","21","9"],["20140211","20","8"],["20140212","18","11"],["20140213","17","7"],["20140214","5","4"],["20140215","3","2"],["20140216","6","2"],["20140217","8","5"],["20140218","35","10"],["20140219","20","13"],["20140220","14","9"],["20140221","19","6"],["20140222","20","4"],["20140223","6","3"],["20140224","20","10"],["20140225","53","9"],["20140226","20","9"],["20140227","42","12"],["20140228","34","8"],["20140301","5","4"],["20140302","11","7"],["20140303","16","9"],["20140304","20","5"],["20140305","25","7"],["20140306","26","11"],["20140307","38","10"],["20140308","10","3"],["20140309","10","5"],["20140310","21","7"],["20140311","17","9"],["20140312","17","6"],["20140313","46","10"],["20140314","33","6"],["20140315","13","4"],["20140316","27","9"],["20140317","19","10"],["20140318","38","15"],["20140319","19","7"],["20140320","22","11"],["20140321","34","17"],["20140322","2","1"],["20140323","12","3"],["20140324","42","8"],["20140325","30","7"],["20140326","21","8"],["20140327","64","36"],["20140328","24","5"],["20140329","25","1"],["20140330","16","2"],["20140331","55","4"],["20140401","37","12"],["20140402","42","17"],["20140403","37","23"],["20140404","40","13"],["20140405","15","3"],["20140406","12","8"],["20140407","23","11"],["20140408","20","11"],["20140409","18","9"],["20140410","21","9"],["20140411","27","18"],["20140412","4","4"],["20140413","7","6"],["20140414","12","6"],["20140415","27","9"],["20140416","28","9"],["20140417","18","13"],["20140418","10","3"],["20140419","3","3"],["20140420","5","3"],["20140421","26","9"],["20140422","28","6"],["20140423","27","2"],["20140424","17","6"],["20140425","17","9"]]}'
            inData = JSON.parse(rowData);
            //alert(inData.rows.length);
            var count = 0;

            var headers = new Array();

            for (var i = 0; i < inData.columnHeaders.length; i++) {
                headers[i] = inData.columnHeaders[i].name;
            }
            //alert(headers);
            var dates = new Array();
            var pageViews = new Array();
            var uniqueViews = new Array();

            for (var key in inData.rows) {
               
                //var dt = new Array();
                //dt[0] = parseInt(inData.rows[key][1]);
                //dt[1] = parseInt(inData.rows[key][2]);
                //dt[2] = parseInt(inData.rows[key][3]);
                //arrayOfArray[count] = dt;
               
                //catogories[count] = inData.rows[key][0];
                //count++
               // if (key == 0 || key == inData.rows.length - 1) {
                    dates[key] = inData.rows[key][0];
               // }
                pageViews[key] = parseInt(inData.rows[key][1]);
                uniqueViews[key] = parseInt(inData.rows[key][2]);
               
            }
            //alert(dates[0]);
            //alert(pageViews[0]);
            //alert(uniqueViews[0]);
            $('#c>5 Pages","columnType":"METRIC","dataType":"INTEGER"},{"name":">5 Mins","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"PDF Downloads":"219","Video views":"47",">5 Pages":"71",">5 Mins":"120"},"rows":[["banner","0","8","0","0","0"],["cpc","2","36","6","9","16"],["email","0","2","3","0","2"],["organic","1","69","13","8","28"],["ppcads","1","16","2","4","10"],["referral","1","88","23","50","64"],["social","0","0","0","0","0"]]}';
            inData = JSON.parse(rowData);
            //alert(inData.rows.length);
            var count = 0;
           
            var headers = new Array();
           
            for (var i = 1; i < inData.columnHeaders.length;i++) {
                headers[i - 1] = inData.columnHeaders[i].name;
            }
            //alert(headers);

            for (var key in inData.rows) {
                //labels[key] = inData.rows[key][0];
                //values[key] = parseInt(inData.rows[key][1]);
                var dt = new Array();
                dt[0] = parseInt(inData.rows[key][1]);
                dt[1] = parseInt(inData.rows[key][2]);
                dt[2] = parseInt(inData.rows[key][3]);
                arrayOfArray[count] = dt;
               // var jsRow = { name: headers[key], data: dt };
               // alert(jsRow);
                //labels[key] = jsRow;
               // if (jsRow.name.length > 1) {
                    catogories[count] = inData.rows[key][0];
                    count++
                //}

                //alert(jsRow.toString());
                   // values[count] = jsRow;
            }
            //alert(arrayOfArray[1][0]);
            var dynamicArray = new Array();
            //alert('cat length ' +catogories.length)
            
            for (var i = 0; i < headers.length; i++) {
                var temp = new Array();
                for (var c = 0; c < arrayOfArray.length; c++) {
                    //alert(arrayOfArray[c][i]);
                    
                    temp[c] = arrayOfArray[c][i];
                    
                }
                dynamicArray[i] = temp;
                //alert(temp);
            }
          
            var js>{series.name}</span>: {point.y} ({point.percentage:.0f}%)<br/>',
                        shared: true
                    },
                    plotOptions: {
                        column: {
                            stacking: 'percent'
                        }
                    },
                    series: 
jsonCollection
                });
            });

//----------------------------------------------- Faahika

//<!-- Which Source/Medium brought more users? - data for column chart-->
		var jsonData = {"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&max-results=10","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:source","metrics":["ga:users"],"sort":["-ga:users"],"filters":"ga:source!=(direct)","start-index":1,"max-results":10},"itemsPerPage":10,"totalResults":30,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&max-results=10","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&start-index=11&max-results=10","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"ga:source","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:users","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:users":"1244"},"rows":[["google","579"],["dianomi.com","277"],["russell.com","197"],["AdsByVSW","110"],["iimagazine.verticalsearchworks.com","11"],["bing","10"],["semalt.com","9"],["Eloqua","7"],["fiduciary-matters.russell.com","7"],["semalt.semalt.com","5"]]};

//<!--Unique visitors-->
//<!-- https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&metrics=ga%3AnewUsers&start-date=2014-01-01&end-date=2014-04-25 -->		
		var UniqueVisitors= {"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:newUsers&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","metrics":["ga:newUsers"],"start-index":1,"max-results":10},"itemsPerPage":10,"totalResults":1,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:newUsers&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:newUsers","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:newUsers":"1330"},"rows":[["1330"]]};
					

//<!--Nurture Activities-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&metrics=ga%3Agoal8Completions%2Cga%3Agoal4Completions%2Cga%3Agoal5Completions%2Cga%3Agoal7Completions%2Cga%3Agoal6Completions&start-date=2014-01-01&end-date=2014-04-25-->	
	
		var NurtureActivities= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","metrics":["ga:goal8Completions","ga:goal4Completions","ga:goal5Completions","ga:goal7Completions","ga:goal6Completions"],"start-index":1,"max-results":1000},"itemsPerPage":1000,"totalResults":1,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:goal8Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal4Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal5Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal7Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal6Completions","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal8Completions":"8","ga:goal4Completions":"247","ga:goal5Completions":"61","ga:goal7Completions":"87","ga:goal6Completions":"143"},"rows":[["8","247","61","87","143"]]}';

//<!--Channels for Nurture Activities-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Amedium&metrics=ga%3Agoal8Completions%2Cga%3Agoal4Completions%2Cga%3Agoal5Completions%2Cga%3Agoal7Completions%2Cga%3Agoal6Completions&filters=ga%3Amedium!%3D(not%20set)%3Bga%3Amedium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
		var ChannelNurtureActivities= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:medium&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&filters=ga:medium!%3D(not+set);ga:medium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:medium","metrics":["ga:goal8Completions","ga:goal4Completions","ga:goal5Completions","ga:goal7Completions","ga:goal6Completions"],"filters":"ga:medium!=(not set);ga:medium!=(none)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":7,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:medium&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&filters=ga:medium!%3D(not+set);ga:medium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:medium","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:goal8Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal4Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal5Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal7Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal6Completions","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal8Completions":"5","ga:goal4Completions":"219","ga:goal5Completions":"47","ga:goal7Completions":"71","ga:goal6Completions":"120"},"rows":[["banner","0","8","0","0","0"],["cpc","2","36","6","9","16"],["email","0","2","3","0","2"],["organic","1","69","13","8","28"],["ppcads","1","16","2","4","10"],["referral","1","88","23","50","64"],["social","0","0","0","0","0"]]}';		
		

//<!-- Top Site Referrers-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Asource&metrics=ga%3Aentrances&filters=ga%3Asource!%3D(direct)%3Bga%3Asource!%3D74.125.225.72&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
		var TopSiteReferrers= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:source","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:source!=(direct);ga:source!=74.125.225.72","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":31,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Source","columnType":"DIMENSION","dataType":"STRING"},{"name":"Entrances","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"1447"},"rows":[["google","677"],["russell.com","300"],["dianomi.com","237"],["AdsByVSW","139"],["iimagazine.verticalsearchworks.com","16"],["bing","12"],["Eloqua","8"],["fiduciary-matters.russell.com","7"],["semalt.com","7"],["semalt.semalt.com","6"],["InstitutionalInvestor.com","4"],["FT","3"]]}';		
		
//<!-- Top Campaigns-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Acampaign&metrics=ga%3Aentrances&filters=ga%3Acampaign!%3D(not%20set)&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
		var TopCampaigns= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:campaign&metrics=ga:entrances&sort=-ga:entrances&filters=ga:campaign!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:campaign","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:campaign!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":11,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:campaign&metrics=ga:entrances&sort=-ga:entrances&filters=ga:campaign!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Campaign","columnType":"DIMENSION","dataType":"STRING"},{"name":"Visits","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"619"},"rows":[["AI NP OCIO - Search Network","442"],["iimagazine","138"],["AI Fiduciary Solutions - Search Network","17"],["AI_14_03_Institutional-Insights-NP_E","8"],["ai-NP_Question_OS_Provider-201402","7"],["ai-042214-Research-tweet----Nonprofit,-managing-risks","2"],["04320e4ee1-corp-newsletter-20140313","1"],["CEA0214","1"],["ai-042414-Research-tweet----Nonprofit,-managing-risks","1"],["ai-NP_Dynamic_Investing-201402","1"],["corp-LinkedIn updates -20140106","1"]]}';

//<!--Top Keywords-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Akeyword&metrics=ga%3Aentrances&filters=ga%3Akeyword!%3D(not%20provided)%3Bga%3Akeyword!%3D(not%20set)&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->		
		var TopKeywords='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:keyword","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:keyword!=(not provided);ga:keyword!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":59,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Keyword","columnType":"DIMENSION","dataType":"STRING"},{"name":"Visits","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"486"},"rows":[["endowment investment policy","118"],["non profit investment policy","101"],["asset allocation +endowment","56"],["nonprofit investment policy","48"],["foundation investment policy","35"],["investments for non profit organizations","13"],["investment management +non +profit","11"],["nonprofit investment strategy","11"],["asset management +foundation","7"],["asset management +non +profit","7"],["asset allocation +foundation","6"],["asset allocation +non +profit","4"]]}';

//<!--Top 10 Web Pages-->	
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3ApageTitle&metrics=ga%3Apageviews&filters=ga%3ApageTitle!%3D(not%20set)&sort=-ga%3Apageviews&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->	
		var WebPages={"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:pageTitle","metrics":["ga:pageviews"],"sort":["-ga:pageviews"],"filters":"ga:pageTitle!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":77,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Page Title","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:pageviews":"3237"},"rows":[["Outsourced CIO (OCIO) for Non-Profits | Russell","1036"],["Outsourced CIO (OCIO) for Non-Profits | Russell Investments","344"],["Benefits of outsourced CIO for your non-profit | Russell","134"],["Resources & research for non-profits | Russell","118"],["Investment strategy research | Russell","100"],["Meet Russell's experienced non-profit team | Russell","96"],["Choosing the right outsourced CIO for your non-profit | Russell","81"],["Investment outsourcing fee basics | Russell Investments","74"],["Governance research | Russell","72"],["Benefits of outsourced CIO for your non-profit | Russell Investments","67"],["Fiscal year 2013 performance drivers – Endowments and Foundations | Russell","65"],["The complete fiduciary: Choosing a provider to share duties | Russell","57"]]};		
		
//<!--Social Networks-->	
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3AsocialNetwork&metrics=ga%3Apageviews&filters=ga%3AsocialNetwork!%3D(not%20set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12--> 
		var SocialNetworks='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:socialNetwork&metrics=ga:pageviews&filters=ga:socialNetwork!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:socialNetwork","metrics":["ga:pageviews"],"filters":"ga:socialNetwork!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":1,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:socialNetwork&metrics=ga:pageviews&filters=ga:socialNetwork!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Social Network","columnType":"DIMENSION","dataType":"STRING"},{"name":"Visits","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:pageviews":"3"},"rows":[["LinkedIn","3"]]}';		

//<!--Top 10 Research Documents-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3AeventLabel&metrics=ga%3Agoal4Completions&sort=-ga%3Agoal4Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=15-->
		var ResearchDocuments='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=10","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:eventLabel","metrics":["ga:goal4Completions"],"sort":["-ga:goal4Completions"],"start-index":1,"max-results":10},"itemsPerPage":15,"totalResults":37,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=10","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&start-index=16&max-results=10","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"Document Title","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal4Completions":"243"},"rows":[["private-foundation-case-study.pdf","33"],["russell-client-case-study-nonprofit-school.pdf","32"],["fiscal-year-2013-performance-drivers-endowments-and-foundations.pdf","29"],["know-what-you-are-buying.pdf","21"],["drivers-of-investment-management-success-for-non-profit-organizations.pdf","18"],["brochure-non-profit-organizations.pdf","17"],["2014-global-annual-outlook.pdf","16"],["7-key-questions-to-ask-ocio.pdf","12"],["brochure-non-profit-organizations.pdf","10"],["governance-implications-of-ny-non-profit-revitalization-act-.pdf","7"]]}';		

//<!-- Top Videos -->	
//<!-- https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3AeventLabel&metrics=ga%3Agoal5Completions&sort=-ga%3Agoal5Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=6 -->
		var TopVideos='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=6","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:eventLabel","metrics":["ga:goal5Completions"],"sort":["-ga:goal5Completions"],"start-index":1,"max-results":6},"itemsPerPage":6,"totalResults":37,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=6","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&start-index=7&max-results=6","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"Video","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal5Completions":"57"},"rows":[["2014 global market outlook","21"],["four questions to ask your outsourced investment provider","17"],["three steps to help you dynamically manage your investment portfolio","12"],["multi-asset solutions: a total portfolio approach","4"],["latest trends among us non-profits","2"],["multi-asset solutions","1"]]}';
		
		BarChart(jsonData);
		DrawGoogleTable(NurtureActivities,[0,1,2,3,4],'table_div4',false);
		DrawGoogleTable(ChannelNurtureActivities,[1,2],'table_div5',false);
		DrawGoogleTable(TopSiteReferrers,[0,1],'table_div6',false);
		DrawGoogleTable(TopCampaigns,[0,1],'table_div7',false);
		DrawGoogleTable(TopKeywords,[0,1],'table_div8',false);
		DrawGoogleTable(WebPages,[0,1],'table_div9',true);
		DrawGoogleTable(ResearchDocuments,[0,1],'table_div11',false);
		DrawGoogleTable(SocialNetworks,[0,1],'table_div10',false);
		DrawGoogleTable(TopVideos,[0,1],'table_div12',false);
		}		

//<!-- Unique Visitors -  Draw Table-->	
	  function drawTable3(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div3'));
		table.draw(data, { showRowNumber: false });
	}
	
//<!-- Nurture Activities -  Draw Table-->	
	  function DrawGoogleTable(jsText,columnIndex,divId,isJson) {

		 if(isJson){
		 inData = jsText
		 }else{
		 inData = JSON.parse(jsText);
			}
		 var headers = new Array();

		 var data = new google.visualization.DataTable();
	for (var i = 0; i < columnIndex.length; i++) {
		headers[i] = inData.columnHeaders[columnIndex[i]].name;
		
		var type = 'string';
		if(inData.columnHeaders[columnIndex[i]].dataType == 'INTEGER')
		{ type='number';}		

		data.addColumn(type,headers[i]);
	}
		
	var arrayOfArray = new Array();
	
	 data.addRows(inData.rows.length);
	 for (var key in inData.rows) {
	  
	   var temp=new Array();
	   for(var i=0;i<columnIndex.length;i++){
	  
			temp[i] = inData.rows[key][columnIndex[i]];
		
			data.setCell(parseInt(key),i,temp[i]);
	   }	  
	   
		arrayOfArray[key] = temp; 
	}		
				
		var table = new google.visualization.Table(document.getElementById(divId));
		table.draw(data, { showRowNumber: false });
		
	}
	
//<!--Channels for Nurture Activities -  Draw Table-->	
	  function drawTable5(tbData) {

		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div5'));
		table.draw(data, { showRowNumber: false });
	}
	
//<!-- Top Site Referrers -  Draw Table-->	
	  function drawTable6(tbData) {
	   
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div6'));
		table.draw(data, { showRowNumber: false });
	}			
	
//<!-- Top Campaigns -  Draw Table-->	
	  function drawTable7(tbData) {

		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div7'));
		table.draw(data, { showRowNumber: false });
	}		
	
//<!-- Top Keywords -  Draw Table-->	
	  function drawTable8(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div8'));
		table.draw(data, { showRowNumber: false });
	}	

//<!-- Top 10 Web Pages -  Draw Table-->	
	  function drawTable9(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div9'));
		table.draw(data, { showRowNumber: false });
	}		

//<!-- Social Networks -  Draw Table-->	
	  function drawTable10(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div10'));
		table.draw(data, { showRowNumber: false });
	}
	
//<!--Top 10 Research Documents -  Draw Table-->	
	  function drawTable11(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div11'));
		table.draw(data, { showRowNumber: false });
	}
//<!--Top Videos -  Draw Table-->	
	  function drawTable12(tbData) {
		
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Name');
		data.addColumn('string', 'Count');
	   
		data.addRows(tbData.rows);

		var table = new google.visualization.Table(document.getElementById('table_div12'));
		table.draw(data, { showRowNumber: false });
	}

Using that I can draw a chart using HighCharts JS.

Now I don't know how to do that. So could someone can help me to get out of here please?

Thanks and regards,
Chiranthaka.

Posted 22-Sep-14 1:22am

Chiranthaka Sampath

Updated 23-Sep-14 0:37am

v4

Add a Solution

Comments

Chiranthaka Sampath 23-Sep-14 2:23am

Are there any comments on my question?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2014-09-22T02:00:00

Solution 1

Have your target variable defined in the outer scope (whatever that is, other function or even global)

Then simply assign it in complete handler

JavaScript

function setJsonSer(rowData){
...
...

complete: function (data) {
    rowData = data;
}

Posted 22-Sep-14 2:00am

Sinisa Hajnal

Updated 22-Sep-14 23:51pm

v3

Comments

Sinisa Hajnal 23-Sep-14 2:04am

Then just write rowData = data; in your ajax complete handler.

Please use Improve Question link instead of putting code in comments. Thank you.

Chiranthaka Sampath 23-Sep-14 4:03am

But my dear friend that roWData variable is residing in a separate JavaScript function(). So how am I supposed to pass that particular JSON output to that variable. Usually in JS Functions return statement can be used to return the value so it can be grabbed from outside. The same returning value thing is need to be done within this setJsonSer() function. So that is where I'm stucj with. So could you please kindly give me a clue about that? Thanks.

Sinisa Hajnal 23-Sep-14 4:43am

If rowData is an object (such as an array) or JSON, you can simply pass it into setJsonSer it will be passed as reference. If it is only a string, then you have no choice but to a) create an array, pass it as reference and then read its data element or b) change the scope of rowData to outer scope as per my solution. Try setJsonSer (data) and see what you get :)

Chiranthaka Sampath 23-Sep-14 5:23am

I've updated the question with the code block that was in the previous comment. In that you can find the rowData. I think rowData is an array. So can you show me how to do the rest please? Because I'm confused with this AJAX and JSON.

Sinisa Hajnal 23-Sep-14 5:51am

I've updated the solution...the change is minor...the rest of your function remains the same.Just move var rowData ABOVE setJsonSer call

Chiranthaka Sampath 23-Sep-14 6:43am

I have posted my complete JavaScript code block in the update. So looking at that I think the solution that you have given is not the one needed. So could you check whether how the solution is to be used within that please!

Sinisa Hajnal 23-Sep-14 7:02am

Your code doesn't call setJsonSer at all. And also, looking will not help you. Try it, then decide. In the code you have big block defining rowData...I understand that you want that block replaced with the call to setJsonSer...right?

Chiranthaka Sampath 23-Sep-14 7:21am

You are correct. To get the output from setJsonSer() what should I do?. what are you suggesting me pal?

Sinisa Hajnal 23-Sep-14 8:07am

Change your setJsonSer function to take rowData parameter...then use that parameter in ajax complete...I don't know how to explain it any different.

I'm not even sure which part is not clear :(
Let's try it from the beginning:
Change setJsonSer declaration like this function setJsonSer(rowData)
Change ajaxComplete as per the solution: rowData = data

Call setJsonSer under var rowData declaration.